Child-parent hierarchy does not calculate total duration

kathleens2020

I have a child-parent hierarchy setup for

SH2.PNG

multiple categories, it all rolls up correctly but only one frame calculates the total duration. What am I doing wrong?

SH.PNG

Mike TV

@kathleens2020

After reading up more on it, I think the answer is that the parent row Duration is calculated from the Start Date of the first Child Row to the End Date of the last Child Row. So since you don't have start and end dates on all of those child rows you're not being given a sum.

Try filling in those dates temporarily and I bet it'll add that then.

Mike TV

@kathleens2020

Does that cell allow you to put in the following formula?

=SUM(CHILDREN())

I'm guessing it won't because Dependencies are enabled but if it does, great!

Mike TV

@kathleens2020

After reading up more on it, I think the answer is that the parent row Duration is calculated from the Start Date of the first Child Row to the End Date of the last Child Row. So since you don't have start and end dates on all of those child rows you're not being given a sum.

Try filling in those dates temporarily and I bet it'll add that then.

kathleens2020

Mike TV

You are correct. If you fill out all the child durations and predecessors it updates the parent duration. Thank you!

SH3.PNG