Calculate Percentage

[bigbonesdog]

I would like to create a measure that calculates the percentage in a cross tab.
I have a row called affected type which displays the count for the Service type and a column called parent category. I would like to calculate the percentage by dividing the grand total by sum of each service type or parent category, multiply by 100 and display on my crosstab.
I am new on jasper studio and currently stuck.

I have attached an example.

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

[Rutuja Shinde]

Hi

1) Create a variable  
2) Calculation = Nothing
3) Expression :
      $F{Field1}.doubleValue()/$F{Filed2}.doubleValue())*100  
4) Drag the variable onto the design area of the crosstab component.
5) Double-click the variable to open its expression
     a) By default you can see its expression as $V{Variable_1}