Sum of calculated controls in footers

[David H]

I have a report with the following groupings:
1.) Claimant
2.) Group
3.) Carrier
in the Claimant footer I have the a control named max_ded with the
following calculation =Max([Ded]). I need to be able to sum this
field at the "group level", and then sum the "group level sum" at the
carrier level. I have tried to sum(max([Ded])) and I get error
messages. I have tried Sum([max_ded]) etc.
Any ideas would be greatly appreciated.

Thanks

 

[Guest]

You must use a duplicate of the text box and set its running sum property to
Over Group or Over All. Reference the name of the Running Sum text box in the
Group Footer.