Forum Discussion
% Complete and Planned % Complete is not same
- 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
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
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.
Hello John-project
I tried the solution in the article mentioned and applied it to one of the projects but it doesn't reflect the same percentage although everything is same.
Please see the snapshot below for your info:
I have set the baselines and I am also updating the project with % Complete only.
Your expert support is needed.
- 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"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."
Yes, thank you for putting that but our bosses would like to see the same happening. They didn't know that Microsoft is yet another tool whose % completion calculations is based on certain people.
We usually lock the baselines from the Project Server settings and allow the Project Manager to report on the Actual Start, Actual Finish and Actual Duration on Task for tracking. However this is a different case altogether.
"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?"
Well those are the three columns same as described in the article and the second last column that is Number3 is Planned % Complete I guess. At summary level for Number1 and Number2, I have selected Sum while on Number3, I have selected Average. I copy/paste the same just to see whether we can have the same percentage or not.
Well I think we cannot have the same percentages after all so I think I have to make two custom fields one shows the % Complete and the other Planned % Complete. So no confusion to show the discrepancy between the percentages.
Thank you for all your time.
