Summary Task Percent Complete Incorrect

[mikejw]

Hello,

I have several groupings that have a summary task and 10 milestones (0
duration) underneath. At the moment, 8 of those milestones have been
completed, 2 are incomplete, however, the percent complete on their summary
task is showing 0%. Playing around, I noticed that if I change the duration
from 0 to 1, the corrrect percent complete shows up at the summary level.

Can someone help me understand why the summary task's percent complete is
not being updated as task below it complete?

Thank you,

MikeW

 

[Jonathan Sofer [MVP]]

% Complete is based on duration so that makes sense. It can't determine the
% complete unless all the milestones are complete at which point the summary
will show 100%.

Jonathan

 

[vanita]

Hi MikeW

% complete is based on duration and is connected with the data in the two
columns of 'Actual Duration' and 'Remaining duration'. For milestones these
data are 0 so consolidated % complete for Summary tasks would also be 0.

If for each milestone completion you want to show 10% complete, i.e with 8
milestones complete, Summary task should show 80% complete you may insert a
Text column e.g Text1 and for Summary tasks you may yourself input data
accordingly in that column. You may also customise the Gantt area to show
Text1 data alongwith the bars.

I hope it helps.
Vanita

 

[Jim Aksel]

This behavior is by design. If the subtasks under a summary task are all
milestones (0 duration) then summary %Complete remains at 0% until all
subtask milestones are completed. This is to avoid a division by 0 problem.

Although I do not specifically cover this case, if you read my white paper
on my blog you will see how %Complete is calculated (it is weighted by
duration). In your case, the sum of all the durations is still 0 which is
what creates the problem. Should you be so inclined, visit the link below,
select Project Tips and then hunt for the white paper on Percent Complete
which explains how it is calculated.

Strangely enough, 0/0 in mathmatical terms is 1 by definition (or at best is
indeterminate). What you seek is a count of complete milestones divided by
total number of milestones. You would have to do that in two custom number
fields with formulas and then divide the results at the summary level.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Jim Aksel]

Yes, it is a strange one. There are two competing math rules at play.

1. Any number divided by itself is 1
2. Any number divided by 0 is infinity.

Since this doesn't make sense, it certainly is indeterminate.

We'll leave it to the math PhDs to reconcile. It will give them something
to do

Jim

_______________

 

[Steve House]

Adding to the other's comments, a summary task with only milestones as it's
children makes no sense from a schedule standpoint. The project plan is a
detailed model of exactly what ACTIONS have to take place in order to create
the milestones. All you have there is a to-do list. It gives you no
guidance as to what has to happen to achieve your objectives, thus there is
nothing to measure progress towards those objectives against.