You have updated the work progressed in % complete field, but there is no Project field that will give you the planned % based on the status date.
Create a custom field using a formula calculation the planned % complete, based on the status date.
1. Field : Expected minutes to status date (Number1)
– Insert a Number1 field in Gantt Chart.
– Right Number1 field and choose Custom Fields.
– Under Custom attributes, click Formula and type the below text
IIf([Status Date]<[Baseline Start],0,IIf([Status Date]>[Baseline Finish],[Baseline Duration],Abs(ProjDateDiff([Baseline Start],[Status Date]))))
– Under Calculation for tasks and group summary rows, choose Rollup with dropdown as sum
2. Field : Expected % complete (Text1)
– Insert a Text1 field in Gantt Chart.
– Right Text1 field and choose Custom Fields.
– Under Custom attributes, click Formula and type the below text
IIf([Status Date]=ProjDateValue(‘NA’),”No Status Date”,IIf([Baseline Start]=ProjDateValue(‘NA’),”No BL”,FORMAT([Number1]/[Baseline Duration],”0%”)))
Dear Sai,
Thanks for sharing valuable information.
I get a syntax error message when running “Expected % Complete”
System highlights ‘NA’ as an error.
Please advise
Regards,
NS Pillai
Dear NS Pillai – This works except the ‘ (single quotes) and ” (double quotes) when copied from this blog post is replaced with a different symbols. I request you to replace the single and double quotes with the correct symbols.
Dear Sai,
Please advise what you mean by correct symbols.
I corrected the formula as below still I get syntax error message:
IIf([Status Date]=ProjDateValue(”NA”),”No Status Date”,IIf([Baseline Start]=ProjDateValue(”NA”),”No BL”,FORMAT([Number1]/[Baseline Duration],”0%”)))
Hi, I think there is a problem in the double quotes you have used. See this link http://i.imgur.com/WeFRcXX.png
thanks, it works well when re-typing the double quote
Hi,
I followed the instructions as stated above but for field 2: Expected % complete (Text1), I only get No Status Date for all tasks.
Please advise?