Calculation in a sub-summary
I have two fields in a sub-summary, both of which are totals of a similar field in the body. (e.g. Hours Available & Total Hours Available, and Hours Worked & Total Hours worked) I want to divide one by the other in the sub-summary to get a percentage (e.g. Total Hours worked ÷Total Hours Available = % Worked). That calculation returns the same value for each sub-summary and appears to using be the total of all the records, not just the sub-summary numbers.
Any advice on how to do this calculation?