Jump to content
Changes to the Jaspersoft community edition download ×

Building Calculated Measure to get percentage of a 'Sum' calculated Measure


jhuisman

Recommended Posts

I created a custom measure that pulls the Sum for a specific field using the following formula:

Sum("NumberFieldName", 'RowGroup')

This works perfect but now I need to take the value of another existing measure and divide it by that to get the percentage. So I created another Calculated Measure with the following formula: 

"ExistingMeasure" / Sum("NumberFieldName", 'RowGroup')

This does not return any data and I am not sure why. For the 'Summary Calculation' I have 'None' selected. Not sure if I need to use 'Custom' there or what I would put in there for the Summary Calculation if I did use 'Custom.' 

Does anyone have any suggestions on how I might get this to work? 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...