Hi
I have a report about locations.
Each manager looks after several cost centres, each of which may have one or several cost centres assigned to it.
So the report is grouped by manager, then by cost centre.
Each cost centre has a target.
The columns (in the detail section) are Location, Target, Actual. Where there are several locations for a cost centre, I want to be able to divide the target by the number of locations.
But
I then want to be able to sum up the targets for each manager.
How do I count the number of entries in the 'detail' section?
Thanks
Chris