Skip to Content
0
Former Member
Aug 04, 2016 at 05:40 PM

Calculation between same Group Footer

19 Views

I'm needing to calculate a percentage between the same group footer level. I have a report with 40 group footers (GF1). I want to calculate the 2nd through 40th GF1 Committed amounts as a percentage of the 1st GF1 Committed amount.

In my attached example, for GF1 Category 12 record, I want to divide 0 by 360,400,927.88 (0), then for GF1 Category 21 record, divide 25,777,206 by 360,00,927.88 (.007), etc. Many thanks for your help.


Attachments

Crystal.PNG (221.8 kB)