Find % diff between rows in a rpt. (1 Viewer)

g-richardson

Registered User.
Local time
Today, 15:38
Joined
Mar 4, 2005
Messages
42
I have a report which tracks data on a monthly basis...In my report, I group results on client and show all historical data for each client...

Report looks like:

Record Count ExtractionDate Value
1 31-Jul-06 $872,363.79
2 31-Aug-06 $887,975.98
3 30-Sep-06 $894,804.35
4 31-Oct-06 $929,066.02
5 30-Nov-06 $956,343.68
6 31-Dec-06 $962,749.18

Record count is calculated as =1 over group.

How can I calculate the percent difference for record 2 from 1, 3 from 2, 4 from 3 etc.? In Excel the formula is (c3-c2)/c3, (c4-c3)/c4 etc.

Any help?

Thanks,
Big G:confused:
 

Users who are viewing this thread

Top Bottom