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:
-- 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.