Real Days Calculation on Timesheet

D

David

I am facing a problem with the Timesheet Real Days. On the Portfolio Analyser
I have created a report for Timesheet including Actual Work, Timesheet Days=
Act Work/8, Real Days (should be X resource how many hrs worked if more than
1 project )

AW TSD RD AW TSD RD 12/1 12/1 12/1 12/2 12/2 12/2
X Proj A 0.0h 0 0.00 0.0h 0 0.00 0.0h 0 0.00
Proj B 3.0h 0.375 1.00 9.0h 1.125 1.00 12.0h 1.5 1.00
Total 3.0h 0.375 1.00 9.0h 1.125 1.00 12.0h 1.5 1.00

AWTSD RD
Total Total Total
 
D

David

I am republishing it as it got posted before I completed the question.

I am facing a problem with the Timesheet Real Days. On the Portfolio Analyser
I have created a monthly report for Timesheet including Actual Work(AW)( no of hrs worked by resource X on a daily basis), Timesheet Days (TS)= Act Work/8, Real Days(RD)=AW (show as % of parent row item) (irrespective of no of hrs worked the Real Day should be 1 if person has worked on that day-it is calculated as % of parent row item.)
AW TS RD AW TS RD AW TS RD
Tot Tot Tot
RES 12/1 12/1 12/1 12/2 12/2 12/2
X Proj A 0.0h 0 0.00 8.0h 1 1.00 8.0h 1 0.00
Proj B 3.0h 0.375 1.00 9.0h 1.125 1.00 12.0h 1.5 1.00
Total 3.0h 0.375 1.00 9.0h 1.125 1.00 20.0h 2.5 1.00

The problem faced is in the RD Total I don't get the total of all RD but it
calculates based on the TS total as 1 day.
The TS total is coming correctly ie: total of all TS days (AW total/8). Does
anyone have any suggestion how to calculate the RD total?

Regards,

David.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top