Forum Discussion
Post Prodigyi need help with this one
Hi RvdHeijden,
Im not sure but i think it has something to do with the fact that my initial question was that the duration was given in Workingdays.
but when i see the data in my table it looks like MS Project uses Hours in the database, where in PWA it displays Days.
In that case, you only need to make a little adjustment to the formula:
Working hours per day =
IF (
WEEKDAY ( 'Working Table_2'[Date]; 2 ) IN { 6; 7 };
BLANK ();
'Working Table_2'[Taakwerk] / ('Working Table_2'[Taakduur]/8)
)Regards,
Yuliana Gu
Post ProdigyYuliana, this is the formula im using
Working hours per day =
IF (
WEEKDAY ( 'Working Table_2'[Date]; 2 ) IN { 6; 7 };
BLANK ();
'Working Table_2'[Taakwerk] / 'Working Table_2'[Taakduur]
)
Im not sure but i think it has something to do with the fact that my initial question was that the duration was given in Workingdays.
but when i see the data in my table it looks like MS Project uses Hours in the database, where in PWA it displays Days.
So it looks like we need to change the formula. So we either need a new calculated colum to 'convert' the column 'Taakduur' which is in hours to workingdays or change the formula.
Here is another example because my task takes 8 hours and i get 1 day but here it shows 8 hours so basically the formula should return the value 8
Microsoft EmployeeHi RvdHeijden,
Im not sure but i think it has something to do with the fact that my initial question was that the duration was given in Workingdays.
but when i see the data in my table it looks like MS Project uses Hours in the database, where in PWA it displays Days.
In that case, you only need to make a little adjustment to the formula:
Working hours per day =
IF (
WEEKDAY ( 'Working Table_2'[Date]; 2 ) IN { 6; 7 };
BLANK ();
'Working Table_2'[Taakwerk] / ('Working Table_2'[Taakduur]/8)
)
Regards,
Yuliana Gu