How to Calculate a percentage across two subsummaries?

Discussion created by Malcolm on Aug 17, 2012
Latest reply on Aug 19, 2012 by Malcolm

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?