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"
Member for
15 years 9 monthsRE: Physical % Complete
Thanks Bo!
I can always trust your skills when it comes to theese kind of qustions.
Regards
Dan
Member for
19 years 8 monthsRE: Physical % Complete
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