13 Replies Latest reply on Aug 19, 2012 11:07 PM by Malcolm

    How to Calculate a percentage across two subsummaries?


      I have a reporting problem that I can't seem to resolve. I'm printing a report that has two sub-summary parts and no body part.


      We sort by Groups and by Staff Name and it looks like this:


      Group Name

      -- Staff Name: staff summary data

      Group summary data


      at the record level we have a number field called "workload"

      At the staff level we sum "workload" and express it as a percentage

      At the group level we want to express workload as the sum of the percentages divided by the number of staff in the group.


      It seemed simple in concept but I can't make it work.


      Any suggestions?