How to link BCWP to a customized column I created for physical percent complete

Question

As physical % complete does not roll-up summary tasks, I created a column called 'physical percent complete'. I think I need to link this column to Budgeted Cost of Work Performed (BCWP), just so I can have a more accurate Equivalent Annual Cost (EAC) based on the physical percent complete.

I have tried creating a new column and adding the formula:

baseline cost * physical percent complete

though it does not want to work. My plan was to then create another column for 'estimated at completion' based on the result from previous formula.

Does anyone have an idea on how I can achieve a more accurate EAC based on the customised column for physical percent complete?

Thank you.

Answer 1

BCWP is a non-customizable field in MS Project. However, you can use a customizable field, such as Cost1 to add a formula that uses your other customized field, 'physical percent complete'.

Presuming you used Number1 for that field, enter this as the formula in Cost1:

[Baseline Cost]*[Number1]

Note that even if you override the label for Number1 to say 'physical percent complete', the formula still references the underlying field name, Number1.