Percentage complete in MS Project

Contents:

1. Types columns to set percent complete in MS Project
2. Comparing data of different columns (percent complete) in MS Project
3. Adding graphical indicator for compare column in MS Project
4. Chat

Types columns to set percent complete in MS Project

MS Project Pro has three system column for setting percentage complete. These are the columns:

• "% Complete" - This column shows: "How much of the task's duration was spent." More details in the article "Setting the task actual duration in MS Project Pro".
• "% Work Complete" - This column shows: "How much of the task's work was spent." More details in the article "Adding actual work in MS Project Pro".
• "Physical % Complete" - This column shows: "How much of the task's physical volume was spent." More details in the article "Physical % complete in MS Project Pro".

You can add custom field for calculation percent complete. These are the columns:

• "Cost % complete" - This column shows: "How much of the task's cost was spent" More details in the article "Cost % complete" in MS Project Pro".
• "Plan % complete" - This column shows: "Calculates the percentage of completion of project tasks based on the current date" More details in the article "Plan % complete in MS Project Pro".

Comparing data of different columns (percent complete) in MS Project

You can compare different columns with percentage complete. To do this, you need to create a new custom column with a formula. Consider an example of creating such a column to compare column values: "% Complete" and "Physical % complete".

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

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 "Remaining % complete" name of field.
6. Click the button "Formula..." in the "Custom attributes" block.
7. Add the formula "[% Complete]-[Physical % complete]".
8. Click the "Ok" button in the "Formula for Remaining % complete" window.
9. Click the "Ok" button in the "Custom Fields" window.

Adding graphical indicator for compare column in MS Project

You can use a graphical column to analyze variances in between columns. For example, the green sign shows the minimum deviation. The red sign shows the maximum deviation between the columns.

Steps to create the custom column with graphical indicator in MS Project Pro:

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 "Remaining % complete graph" name of field.
6. Click the button "Formula..." in the "Custom attributes" block.
7. Add the formula "Remaining % complete".
8. Click the "Ok" button in the "Formula for Remaining % complete graph" window.
9. Click the "Graphical indicator ..." button.
10. Choose the rules to test field in the "Test for Remaining % complete graph" column. 
11. Enter a value for the rules in the "Values" column. 
12. Choose a image in the "Images" column.
13. Set rules for summary rows and the project summary.
14. Click the "Ok" button in the "Graphical indicator for Remaining % complete graph" window.
15. Click the "Ok" button in the "Custom Fields" window.