Sum Property in Access

[teneesh]

I've created a report in access, one of my Sum functions on the report is: =Sum([ConfAttendance])/Sum([ConfOffrate]), which is grouped by Conference Type.
Now I'd like to provide a total sum, adding up all the values calculated through the =Sum([ConfAttendance])/Sum([ConfOffrate]) formula. It would be like a grand total. And I'm not quite sure how to do it.

My groupings are by name, conference type. So I was thinking that if i just put the same formula under the name footer grouping, I'd get it. But its not working. Any advice?

Thanks in advance.

[teneesh]

I got it. . . The grouping I was working with, is actually the right way to go. I was just expecting something different. But =Sum([ConfAttendance])/Sum([ConfOffrate]) grouped by name footer did work.