Follow

How can the Planned Progress % be recorded in MSP / PPO?

Step 1 - Implement Number1 Field

Open your Microsoft Project (MSP) plan and implement a new column called: Number1.

FAQ_progress_step1.png

Once the column is added, right-click on the column heading and select the Custom Fields option.
Click on the Formula button.

FAQ_progress_step2.png

Then enter the formula as follows: ProjDurValue([Duration])

Click OK to close the window. Another window will pop up to which you can also respond by clicking on the OK button.

FAQ_progress_step3.png

Under the Calculation for task and group summary rows section click on the Rollup radio button and select Sum from the drop-down list.
Click on OK to return to the Gantt Chart View.

FAQ_progress_step4.png

Step 2 - Implement Number2 Field

As in step 1, implement a Number2 field and enter the following formula on the custom fields settings:
IIf([Finish]<=now(),100,IIf([Start]>now(),0,ProjDateDiff([Start],Now())/ProjDateDiff([Start],[Finish]))*100)*[Number1]/100 

FAQ_progress_step5.png

Click OK to close the formula window as well as the new window that pops up.
As in step 1, click on the Rollup radio button under the Calculation for task and group summary rows section and select Sum from the drop-down list.

FAQ_progress_step4.png

Click on OK to return to the Gantt Chart View.

Step 3 - Implement Text10 Field

As in the previous steps, implement a Text10 field and enter the following formula on the custom field settings:

IIf([Number1]=0,IIf([Finish]<=Now(),100,0),int([Number2]/[Number1]*100)) & "%"
FAQ_progress_step6.png

Click OK to close the formula window as well as the new window that pops up.
For this field, click on the Use Formula radio button under the Calculation for task and group summary rows.

FAQ_progress_step7.png

Click on OK to return to the Gantt Chart View.

Step 4 - Clean up and import

You can clean up your project plan by hiding the Number1 and Number 2 columns and renaming the Text10 field to: % Planned.

FAQ_progress_step8.png

The Planned Progress % field in PPO is already mapped to the tasktext10 field, so no additional mapping is required.

Planned_Progress.jpg

Additional Notes:

If you receive the following error message when implementing the Text 10 field it will be required to use a different formula.

msp.gif

If the above error message is received, the following formula should be implemented into the Text 10 field:

IIf([Number1]=0;IIf([Finish]<=Now();100;0);int([Number2]/[Number1]*100)) & "%"

 

 
Was this article helpful?
2 out of 2 found this helpful
Have more questions? Submit a request
Article is closed for comments.
Start a 30 Day Free TrialClick ClickNo Credit Card and No Obligation
Powered by Zendesk