Calculated Field on Grouped Records

[hikerdood]

I added Grouped Records and totaled 2 columns that hold Total Hours and OT Hours. I want to add a 3rd calculated text box that will divide the OT Hours by the Total Hours to get a percentage. When I enter the below text box formula in the grouped area it calculates a percentage on the row above the grouped totals. I cannot get it use the 2 grouped totals.



=Sum([OT Hours])/([Total Hours])

Appreciate any help

Thank you

Gene

[pbaldy]

Try

=Sum([OT Hours])/Sum([Total Hours])

[hikerdood]

Thank you Paul..works perfectly.

Gene

[pbaldy]

No problem Gene.