Child-parent hierarchy does not calculate total duration
I have a child-parent hierarchy setup for
multiple categories, it all rolls up correctly but only one frame calculates the total duration. What am I doing wrong?
Best Answer
-
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.
Answers
-
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!
-
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
You are correct. If you fill out all the child durations and predecessors it updates the parent duration. Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives