Calculatiuon problem

[kentwoodjean]

I have a report that has a group footer and a report footer with the formula:

=Sum([CountOfCONTRACT])

I have added a column to show the % to grand total for each item within a group and it works just fine. It is:

=([CountOfCONTRACT]/Sum([CountOfCONTRACT]))

What I am having trouble doing is getting a formula right for the % to Grand Total for each group footer total. Because I would be dividing the group footer by the report footer (which are the same) I continue to get aggregate errors. Any idea how I can do this?

 

[Zonie32]

maybe something like...

=([CountOfContract]/[CountOfContractGrandTotalSum]) or whatever the Name of your grand total textbox is??