Plan % complete in MS Project Server

Contents:

1. Creating the custom column "Plan % complete" in MS Project Onine
2. Compare the "Plan % complete" column with the "% complete" column in MS Project Server
3. Using graphical indicator for custom column "Remaining % complete" in MS Project Server

Creating the custom column "Plan % complete" in MS Project Onine

The project manager can update the project after the end of the implementation period. But in the during project implementation project, manager want to know, what percent complete must be for each tasks. We can calculate it using the current date.

Steps to create the custom column "Plan % complete" in MS Project Pro:

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 "Plan % 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 "Number" in the "Type" field.
9. Select the Formula in the "Custom Attributes" block.
10. Enter the formula: "IIf(NOW()<[Start],0,IIf(NOW()>[Finish],100,CLng(((NOW()-[Start])/([Finish]-[Start]))*100)))".
11. Set the "Use formula" box in the "Calculation for Summary Rows" block.
12. To save click the "Save" button.

Compare the "Plan % complete" column with the "% complete" column in MS Project Server

You can analyze the execution, compare the "Plan % Complete" column with the "% Complete" column.

Steps to create the custom column "Remaining % complete" in MS Project 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 "Remaining % 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 "Number" in the "Type" field.
9. Select the Formula in the "Custom Attributes" block.
10. Enter the formula: "[% Complete]-[Plan % complete]".
11. Set the "Use formula" box in the "Calculation for Summary Rows" block.
12. Set the "Graphical indicators" box in the "Values to Display" block.
13. Enter the rules. (Read more "Adding a enterprise custom field with graphical indicators in MS Project Server")
14. To save click the "Save" button.

Using graphical indicator for custom column "Remaining % complete" in MS Project Server

You can add graphical indicator to show the result of comparing the "Plan % complete" column with the "% complete" column

Steps to add custom columns: "Plan % Complete" and "Remaining % complete" 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 Tracking" view.
4. Add columns: "Plan % Complete" and "Remaining % complete" in the "Fields" block.
5. To save click the "Save" button.

Steps to use custom columns: "Plan % Complete" and "Remaining % complete" 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 Tracking" view in the "View" field in the "Data" block.
5. Click the "Edit" button in the "Project" block and select the "In Browse" item.