none
How to change roll-up summary calculation? RRS feed

  • Question

  • Hi,

    I am creating an MS Project Pro 2010 schedule. The roll-up summary durations are calculated by default based on the start/end dates of the child tasks. But what I want is to show sum of actual time duration of each task instead. For instance, in the following screenshot the roll-up is showing a total of 14 hours. However I need it to show 3 hours as all individual child tasks sum up to 3.

    Please can you advise how can I achieve this?

    Thanks,


    Khalid Ashraf

    Wednesday, August 22, 2012 4:20 PM

Answers

  • Khalid,

    For that you will need to create a custom field. It is as simple as putting the following formula into an extra duration field (e.g Duration1) and then setting the calculation for task and group summary lines to be as "sum".

    Duration1=[duration]

    John

    • Marked as answer by Khalid Ashraf Wednesday, August 22, 2012 4:37 PM
    Wednesday, August 22, 2012 4:26 PM