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