I am do this but get a #ERROR at step 2
MS Project Planned % Complete
In MS Project there is no Planned % Complete Column to show the forecast. The following steps will give us the %Planned for entire project.
STEP 1:
MS Project stores the duration in minutes, in order to use duration in days in our calculation we have to create column based on duration in days.
Right click any column and select insert column. Then select field name as Number1.
Then right click Number1 column and select Custom Field. On the custom attributes click on the radio button “Formula” and then type copy paste the formula as below and press OK.
Val(ProjDurConv(Duration,pjDays))
In the next section click on “Use formula” radio button and click OK.
STEP 2:
Based on the start date of the project and the status date, calculate the days elapsed. This is required to calculate the percentage.
Right click any column and select insert column. Then select field name as Number2.
Then right click Number2 column and select Custom Field. On the custom attributes click on the radio button “Formula” and then type copy paste the formula as below and press OK.
IIf(ProjDateDiff(Start,[Status Date])/480>=Val(ProjDurConv([Baseline Duration],pjDays)),Val(ProjDurConv([Baseline Duration],pjDays)),IIf(DateDiff("d",[Baseline Start],[Status Date])<=0,0,ProjDateDiff(Start,[Status Date])/480))
In the next section click on “Use formula” radio button and click OK.
STEP 3:
To get the planned value right click any column and select insert column. Then select field name as Number3.
Then right click Number3 column and select Custom Field. On the custom attributes click on the radio button “Formula” and then type copy paste the formula as below and press OK.
Number2/Number1
In the next section click on “Use formula” radio button and click OK.
STEP 04:
To display the percentage complete field as text with a % sign, create a new text field column and in the formula format the Number3 field.
Right click any column and select insert column. Then select field name as Text2.
Format(Number3,"0%")
In the next section click on “Use formula” radio button and rename the Text 2 by %Planned.
Hide Columns Number1 to Number3
