2 Replies Latest reply on Jan 4, 2013 1:42 PM by ChristopherR.Spence

    Calculation in a sub-summary

    ChristopherR.Spence

      Title

      Calculation in a sub-summary

      Post

           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?

           Thanks