Roll-up Costs of Grandchildren

RKLRpp

Good Afternoon-

I used a formula to roll-up costs that were tabulated in a separate column with: =SUM(CHILDREN([Labor Total]@row)). Unfortunately, this only sums direct children of any given row, it works fine for 2 levels. It does not sum "grand children" of rows that multiple levels of hierarchy beneath them. Any suggestions? Thank you.

Amanda Alv

Hi,

If you change "Children" to "Descendants", you should get the result you are looking for.

Good luck!

RKLRpp

Oh perfect...I forgot about that one.