I'm having a problem adding summerized totals in a report that has 3 groups but these totals are in a single group footer. Each total is on a seperate page.

 

Here is a example.

 

10               12             11

10               12             11

10               12             11

total 30       total 36     total 33

 

I'm looking for a grand total of the three (99) to be added in the report footer of my report. I have tried many combinations in my formula but none have worked and I cannot use the summed total in my report because it won't let me.

 

Here is my formula right now:

 

Sum ({CLAIMANT_COVERAGE_FIN.TOTAL_INCURRED}, {CLAIM.CLAIM_NUMBER}) + Sum ({CLAIMANT_COVERAGE_FIN.TOTAL_INCURRED}, {LOCATION.DISPLAY_NAME})

 

Any help with this would be greatly appreciated.

 

Thanks

Joe

 

 

 

Here is the formula I have created and it works in the level that I have made the totals but when I drag it to the report footer it adds only one amount. if possible would you have any idea why this is happening. If you need any more information about the report please ask.

 

shared numberVar totinc := totinc + Sum ({CLAIMANT_COVERAGE_FIN.TOTAL_INCURRED}, {CLAIM.CLAIM_NUMBER})

 

Thank you

Joe