AnsweredAssumed Answered

Calculation in a sub-summary

Question asked by ChristopherR.Spence on Jan 3, 2013
Latest reply on Jan 4, 2013 by ChristopherR.Spence


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?