% of performing RRS feed

  • Question

  • Hi all)

    in MS Project i have a one of summary task, that contain only milestones(30-40 approximately);

    when i change % of completion from 0 to 100% of half of this milestones, summary task must show me 50% of completion, but it doesn't, and show me 0%

    but if i change % of all milestones to 100%, summary task show me 100%

    question: what i should to do, that summary task will show me % of completely proportionally finished milestones

    thanks a lot))

    Tuesday, July 28, 2015 2:26 PM


  • Hi,

    The % complete is: (Actual Duration / Duration) * 100. So this is normal that it returns 0% for milestones since they are a null duration. Once all the sub tasks are completed, then automatically the parent task is set to completed also.

    You could create a custom field (number type) with a formula set to 1 if the milestone is completed: Iif([% complete]=100; 1; 0). Then set a average rollup for summary rows.

    Note that it is a simple solution which can be enhanced with a more elaborated formula, even VBA.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller |

    • Proposed as answer by John - Project Tuesday, July 28, 2015 3:02 PM
    • Marked as answer by Arkennya13 Wednesday, October 21, 2015 12:02 PM
    Tuesday, July 28, 2015 2:53 PM