How can the Planned Progress % (percentage) be recorded in MSP?

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.
FAQ_progress_step9.png
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)) & “%”

Read More: http://support.ppolive.com/entries/20738467-How-can-the-Planned-Progress-percentage-be-recorded-in-MSP-PPO-

Recommended Reading

Author: Tarmizi Sukarno

Im a part time internet marketer, Online Seller, Offline Seller, and Creative Advertiser Implementer. Feel free to contact me at +6011-38800002 for free consultations to improve your business.