Hi,
I have created a report and used the grouping functionality to group 3 sets of data. However, the first two groups are summed in the group footer. However, I want to be able to divide group 2 into group 1 to come up with a rate in the 3rd group.
Example
GROUP 1
Accum Depn A - $10,000
B - $20,000
SubTotal_Accum $30,000 This Subtotal is a sum of A & B
GROUP 2
Depreciation Expense C - $1,000
D - $4,000
SubTotal_ DepnExp $5,000 This Subtotal is a sum of C & D
GROUP 3
Rolling Current Year Trend
10.00
5.00
Sub Total 6.00 This SubTotal is SubTotal_Accum/SubTotal_DepnExp
I am using Access 2010
Thanks
Ian