Skip to content

Physical % Complete

Dan MårtenssonMember for 16 years 8 months
Created
2
2
0
Hello,

I need help with a formula.

I want to display in a new column hours based on physical % complete.

My existing formula is

([Physical % Complete]*[Baseline Work]/60)

This doesn’t work! Why?

Please help

Regards

Dan M

2 replies

Oldest first
  1. 0
    Bo Johnsen ·
    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
  2. 0
    Dan Mårtensson ·
    Thanks Bo!

    I can always trust your skills when it comes to theese kind of qustions.

    Regards

    Dan

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?