Quick Links

How % Complete is calculated for nested summary tasks

Home Forums Discussion How % Complete is calculated for nested summary tasks

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • #403653 Reply
    Alan Abrahams

    In the table below, “Plan Trial” is the Summary total for the 4 Sub-total tasks below it.
    Each of the 4 Sub-total tasks have from 4-10 tasks each.
    I have reconciled thee “% complete” for each of the 4 Sub-total lines.
    However, I cannot reconcile the “% complete” for thee “Plan Trial” line. It shows as 93% (which is = Actual Duration/Duration) BUT is does not match the weighted calculation based on the 4 Sub-totals below.
    Does anyone know why this occurs?

    Task Name Start Finish Duration % Complete Actual Duration
    Plan trial Mon 8/08/16 Fri 23/09/16 35 days 93% 32.57 days
    Draft and Approve Requirements Specification Mon 22/08/16 Thu 8/09/16 14 days 100% 14 days
    Prepare trial implementation plan Mon 22/08/16 Wed 14/09/16 18 days 97% 17.43 days
    Plan how to place the device into the vehicle Mon 8/08/16 Fri 23/09/16 35 days 54% 18.93 days
    Specify Trial Case(s) Mon 15/08/16 Wed 14/09/16 23 days 100% 23 days

    #403654 Reply
    Larry Christofaro

    Try the article here and see if that helps: https://support.microsoft.com/en-us/kb/101495
    Hope that helps…

    #403655 Reply
    Alan Abrahams

    Hi Larry,

    I had already worked through this document but it did not give me the answer I am seeking.
    I applied exactly the same logic as the example in this article, but my equivalent to the “Top Summary” does not result in the correct outcome for me.

    #403684 Reply

    We’ve run into two items that may be causing your scenario.
    1) The Summary Task is a manually scheduled task. When it is configured this way, the automatic roll up / summarization of the sub-tasks does not occur. Change the summary task to auto scheduled.
    2) There’s a scheduling option (File>Options>Schedule) “Updating task status updates resource status” that should be checked. if you hover over the information icon next to this option, you’ll see that it impacts calculations of % complete.

    No guarantees, but try checking these two items.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Reply #403655 in How % Complete is calculated for nested summary tasks
Your information:

45 − = 38