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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives