Physical % Complete
Forum Sponsor
Top Posters
Ricky
0 posts
pinoyplanner
1 posts
Siddharth Ranadive
1 posts
Aidar Kurmantayev
0 posts
Dave Morgan
0 posts
blake333_
0 posts
Mohammed Netarwala
12 posts
Moahmed
0 posts
S Z
4 posts
Iftikhar Awan P.Eng.
19 posts
Thanks Bo!
I can always trust your skills when it comes to theese kind of qustions.
Regards
Dan
Hi Dan,
Your formula does work, but needs minor adjustment.
If using a Number-field your formula should look like:[Physical % Complete]*[Baseline Work]/60/100 (the parentheses as you have written are optional - in this case)
and if using a Duration-field the formula should be:
[Physical % Complete]*[Baseline Work]/100, but then at the same time remember that under Tools-Options-Schedule Tab, the "Duration is entered in:" should be set to "Hours" to get the right result. However, then you should be aware that what you enter in the "Duration"-column is by default hours unless adding you add the right unit (e.g. d, w, etc.).
If using the Number-field and you want the "hrs" to be written at the back you can just make a new Text-field with the formula: [Numberx] & " hrs"
Regards,
Bo