I have a report summarizing time and calculating overtime/regular time percentages and totals according to a 40-hour baseload.
Allocation by
Who What HowLong %OfWorked 40hr-Baseload
(%OfWorked*40)
GH3 Joe Project1 10hours 20.00% 8 hours
GH3 Joe Project2 30hours 60.00% 24 hours
GH3 Joe Project3 10hours 20.00% 8 hours
GH3 Joe Vacation 8hours n/a 8 hours
GF1 Joe Total: 58hours TimeOff: 8hours Worked: 50hours TotalAllocation: xxx
The %OfWorked calculated field is dependent on the Worked field in the GF1 -- that is, I can't calculate each GH3's %OfWorked until I know the total Worked hours for Joe. And the Allocation field is dependent on the %OfWorked field, so it is also dependent on the GF1 Worked total. But I also need to sum the Allocation column and put it in GF1 in the xxx space. I can't add a Summary on the Allocation field because it's calculated on the GF1 Worked calculated field.
How can I sum a calculated field from a lower-group level to a higher-group level when the calcuation is dependent on a field calculated at the higher-level group?
Thanks,
wbbroyles