How to calculate planned % Complete?


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%”)))

Advertisements

6 thoughts on “How to calculate planned % Complete?

  1. 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

  2. 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%”)))

  3. 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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s