Weighted % Complete calculation

Discussion in 'Project' started by Robert Cortese, Feb 26, 2018.

  1. Robert Cortese

    Robert Cortese

    Feb 26, 2018
    Likes Received:
    Hello MS Project Guru's,

    I am using MS Project 2010 and am trying to create a weight percent complete. I understand the % Complete = (Actual Duration / Duration) * 100. But I need a % complete based on the weight of each task.

    So I created a custom field, Weight[Number1], to denote the weight of each task and populated each task with its associated weight. The weight equals 100 for each Child Summery task when it is a 100% complete.

    Then created a second custom field, Weight Complete[Number2], and used the formula [% Complete]*[Number1]/100 and set the task and group summary rows to Rollup on the sum.

    The third custom field, Weight % Complete[Text3], applies a “%” by using formula [Number2] & " %" and setting the task and group summary rows to Use Formula.

    All is working properly for the Child Summery tasks. Where things are breaking down are at the Work Package 1 summery task level. Nothing should go over a 100%, yet the summery task rows are showing numbers like 285% and 385%.

    How do I get the Summery Task rows to reflect the percentage complete and not the sum of all the Child Summery tasks under Work Package 1?

    Any help would be appreciated. Unfortunately, I am unable to upload my .mpp demo to show you what I'm looking at. Attached is the Excel version.


    Attached Files:

    Robert Cortese, Feb 26, 2018
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.