Calculation "Cost % complete" in MS Server

Contents:

1. Creating the custom column "Cost % complete" in MS Server
2. Using the custom column "Cost % complete" in MS Server
3. Chat

Creating the custom column "Cost % complete" in MS Server

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 the custom column "Cost % complete" in MS Server:

1. Open MS Project Server
2. Click the "Server Settings" item in the left menu.
3. Click the "Enterprise Custom Fields and Lookup Tables" item in the "Enterprise Data" block.
4. To create the custom fields, click the "New Field" button.
5. Enter the "Cost % complete" in the "Name" field.
6. Enter the field description in the "Description" field. 
7. Select the "Task" in the "Entity" field.
8. Select the "Numeric" in the "Type" field.
9. Select the Formula in the "Custom Attributes" block.
10. Enter the formula: "IIf([Cost] = 0, 0, [Actual Cost] * 100 / [Cost])".
11. Click the "Use formula" box in the "Calculation for Summary Rows" block.
12. To save click the "Save" button.

Using the custom column "Cost % complete" in MS Server

Steps to add custom columns: "Cost % complete", "Cost" and "Active cost" in MS Project Server:

1. Click the "Server Settings" item in the left menu.
2. Click the "Manage Views" item in the "Look and Feel" block.
3. Click the "Tasks Cost" view.
4. Add columns: "Cost % complete", "Cost" and "Active cost" in the "Fields" block.
5. To save click the "Save" button.

Steps to use custom columns: "Cost % complete", "Cost" and "Active cost" in MS Project Server:

1. Click the "Projects" item in the left menu.
2. Select the project and click the project name.
3. Click the "TASK" item in the top menu. 
4. Select the "Tasks Cost" view in the "View" field in the "Data" block.
5. Click the "Edit" button in the "Project" block and select the "In Browse" item.