Sum of calculated controls in footers

D

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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top