Showing % Complete when Grouped

K

ko

How can I get the % complete to accurately show up on the Group BY summary
with the % complete of summary tasks included? Meaning I have a bunch of
tasks grouped together that include summary tasks, and the Group row only
calculates the % complete of the subtasks and not the summary level ones. Any
way around this?
 
J

John

ko said:
How can I get the % complete to accurately show up on the Group BY summary
with the % complete of summary tasks included? Meaning I have a bunch of
tasks grouped together that include summary tasks, and the Group row only
calculates the % complete of the subtasks and not the summary level ones. Any
way around this?

ko,
Remember that the value shown for % Complete on a Summary Line is a
calculated value to begin with and it is based on the ratio of Actual
Duration to total Duration of performance subtasks under that Summary
Line. To include the % Complete of Summary Lines along with performance
tasks in a group will give dubious results at best and flat out wrong
misleading information at worst. The only value that would make some
sense is if all the subtasks under the Summary Line were in the same
group as the Summary Line. If that's the case, then the value at the
group level is probably already the correct value (i.e. % Complete on
Summary Lines in the group is irrelevant).

Now, to answer your question. Yes, a formula could probably be developed
for a VBA macro to show a value, but, see the above paragraph.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top