Jump to content

Calculate Percentage

Go to solution Solved by Rutuja Shinde,

Recommended Posts

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.

Screenshot 2023-11-20 114256.png

Link to comment
Share on other sites

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.

  • Like 1
Link to comment
Share on other sites

  • Solution


1) Create a variable  
2) Calculation = Nothing
3) Expression :
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}

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...