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