Forum Discussion

tanzimshaikh's avatar
tanzimshaikh
Brass Contributor
Aug 01, 2024

% Complete and Planned % Complete is not same

Hello Experts,

I have a scenario where I am running a project. Following is the implementation of the same:

 

There are no dependencies in the project and neither the baselines for my project. I have just used the % Complete to update the project.

The formula for the Planned % Complete is as follows:

IIf([Start]>Now(),0,IIf([Finish]<Now(),100,(ProjDateDiff([Start],Now(),[Project Calendar])/[Duration])*100)) 

 

A very simple project but the percentage is not coming the same. Why?

 

Regards

  • John-project's avatar
    John-project
    Aug 08, 2024
    tanzimshaikh,
    You say you need % complete and planned % complete at summary level to be the same. Why? Typically they will not be the same even if calculated in the same manner. Percent complete is independent of the status date whereas any planned percent complete calculation at summary level will be dependent on the status date.

    Percent complete at summary level, whether calculated by Project using the formula Ignacio presented, or calculated via a custom formula/process, is dubious at best. In other words, summary level percent complete is highly subjective. In fact, percent complete based on duration is in my view pretty meaningless since the passage of time (duration) doesn't accomplish anything, unless its paint drying, concrete curing, or a wound healing.

    In your screen shot you show three custom number fields. What exactly do each of them represent (i.e. formulas)? And how do you calculate Planned % Complete at summary level?

    John
  • Hitanzimshaikh 

    That formula should only be applied to normal tasks (not summary tasks), as Project's way of calculating % complete for a summary task is: 100 x Sum of Actual Durations of Subtasks / Sum of Subtask Durations.

    Also, that formula you mention does not always give the correct result for certain normal tasks, such as if there have been interruptions in the actual part, and the task is not continuous.

    I hope I have helped you.

    Ignacio

    • John-project's avatar
      John-project
      Silver Contributor

      tanzimshaikh 

      Sorry, but without a baseline there is no "planned % complete".

       

      Ignacio already gave you the formula Project uses to calculate percent complete at summary level. To replicate that in a formula you will have to create a couple of custom duration fields that sum up the Duration and Actual Duration field to summary level and then use a third custom field to implement the formula Ignacio gave you.

       

      But instead of that, I suggest you take a look at the following article:

      https://mpug.com/planned-and-actual-percent-complete-in-ms-project/

       

      John

      • tanzimshaikh's avatar
        tanzimshaikh
        Brass Contributor

        John-project 

        Well, I know that without baselines no plans but I wanted to know why the percentages are coming different. 

        I shall look at the link that you send it, in sha' Allaah (God Willing).

        Thank you for your suggestion John.

Resources