Michael_D
asked on
calculate weekly average
Hi
I am trying to calculate weekly averages of hours worked per employee
My data structure is as following
employee Table
empId
empName
service table
serviceId
empId
DateComplete
BillableHours
Report structure should be like this:
GH1 - Employee name Average Weekly Hours
GH2 - Week of (based on DateComplete ) - Total hours (sum of BillableHours)
D - suppressed - no drill down
I have all done except Average Weekly Hours
Can anybody point me to the right direction?
I am trying to calculate weekly averages of hours worked per employee
My data structure is as following
employee Table
empId
empName
service table
serviceId
empId
DateComplete
BillableHours
Report structure should be like this:
GH1 - Employee name Average Weekly Hours
GH2 - Week of (based on DateComplete ) - Total hours (sum of BillableHours)
D - suppressed - no drill down
I have all done except Average Weekly Hours
Can anybody point me to the right direction?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could use running totals or formulas but those methods wouldn't give you the ability to put it in the group header.
mlmcc
mlmcc
ASKER
Exactly - that what i was struggling with ...
I tried to use Running totals with no luck.
Thank you again!
I tried to use Running totals with no luck.
Thank you again!
ASKER
Working perfect!
Just out of curiosity you said the this is "One Way to try ..."
What are the other possibilities?