Have a report with two groups: Organization and Group. I total the number of records by for each group and total for each organization. I want to divide the total for each group by the total for the organization to get a percentage. I know I can do this using Summary fields but the counting of records by group is conditional. I cannot get the percentages at the group level to be based off the total at the organization level. It only basis the the calculaiton off the running organization vlaue.

 

How to get Crystal to let me base my group percenatages off of the grand total for an organization? This should be simple but I cannot get it to work.

 

Thank you.

Tier1

    Value 1 = 100

    Value 2 = 50

    Value 3 = 150

Total Tier 1 = 300

 

I need to be able to calculate each Value as a percentage of the total for  the tier but I cannot figure out how to get the total to accumulate before calculating the percentage. The only thing I can do is get the percentages based of the running total: 100, 150, 300.

 

The draw back to this method is that the data is read twice or more, and this can slow down the report.  If you were using a stored proc, you could have that calculcate the Tier1 total and have it in the row, which would make your calculations easier...Ah we don't always get to be lucky.

 

Hope this helps a bit more.

For this example the formula for the "1 else 0" is named "Count".

Create another formula for you percentage and include an if then for the sum = 0 option to avoid a division by zero error...

 

 

Place this on your group footer 2.