>For some reason the solution is eluding me so I ask with extreme thanks (also please forgive the possibility that the answer is just running away from me):
>
>Office Month Sales Receipts Gross-%
>1 1 100000 40000 40%
>1 2 110000 41000 37%
>2 1 500000 100000 20%
>2 2 520000 110000 21%
>
>For each line there is a net collection percentage of Receipts / Sales.
>
>On the group footer for Office, I am drawing a blank on how to create the same group footer total of Receipts / Sales in that group footer?
>
>Thanks in advance.
>--rab
You would need to create two report variables
nSalesTotal and nReceiptsTotal with reset on group and Sum option checked. Then you would just use these two variables.
If it's not broken, fix it until it is.
My Blog