Calculation "Cost % complete" in MS Project Pro

<< Back

Contents:

  1. Create custom column "Cost % complete"
  2. Chat


Create custom column "Cost % complete"

You can control the progress of project tasks by tracking project costs. This is a simpler implementation of the earned value method. You don't need to set the baseline or set the percent of complete. The method uses the sum of planned and actual costs. You create a custom column in which you calculate the earned value percentage. You can compare this column with other progress control columns.

Steps to create custom column "Cost % complete":

  1. Click the "Custom Fields" button in the "Properties" block in the "Project" item of the top menu.
  2. Select field type "Task" in the "Field" block. 
  3. Select type "Number" in the "Type:" field.
  4. Select the empty field in the table and click the "Rename ...." button.
  5. Add the "Cost % complete" field.
  6. Click the "Formula ..." button. 
  7. Add the formula: "IIf([Cost]=0;0;[Actual Cost]*100/[Cost])".
  8. Click the "Ok" button.
  9. Click the "Ok" button.

Create custom column "Cost % complete"


#msprojectpro, #oberemokii, #projectmanagment, #projectcostmanagement, #monitoringandcontrollingprocess

Calculation "Cost % complete" in MS Project Pro

2023-09-14 18:17:01

Ivan Oberemok

oberemokii@gmail.com

Chat


Chat for registered users only Login