How to Fix: Value of Parent Row (days) Not Showing the Sum of the Childrens' Rows (days)

Des
Des
edited 10/19/21 in Formulas and Functions

We may have run into a bug with a value on a parent row. The duration of days should be 15 days because the sum of the childrens' rows is 15 (5 tasks, 3 days each), but the parent row displays 25 days. Where could this be pulling from?

Can anyone provide some direction?

See Row 18 in the attached screenshot.


Thanks!

Des

Best Answer

  • Des
    Des
    Answer ✓

    Thanks so much, Genevieve! I appreciate it.

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Des

    The Parent Rollup Functionality takes the first/earliest Child Row Start Date and the last/latest Child Row End Date in order to give you an overview of how long all of the children tasks will take from start to finish.

    Your first Start Date is 01/03/23 on row 22, and your last End Date is 02/06/23 on row 21. Therefore, the working day duration for the Parent row is 25d! Does that make sense?

    See: Parent Rollup Functionality

    Cheers,

    Genevieve

  • Des
    Des
    Answer ✓

    Thanks so much, Genevieve! I appreciate it.

  • Genevieve P.
    Genevieve P. Employee Admin

    No problem! 🙂