Average % Complete for Parent row with multiple Hierarchy levels under them

jnev

Hi all. I'm trying to calculate the Avg for % Complete on my top parent row. That row has direct children but also children who are also parents...if that makes sense. I'm looking to calculate the Avg % Complete of the entire hierarchy below the top parent. AVG(CHILDREN()) only returns the avg % of the direct children, not including what I'm referring to as "grandchildren"

Photo Sample below. Thanks in advance!

Paul Newcome

Try putting the AVG(CHILDREN()) on every parent row regardless of level of hierarchy so that it just rolls on up.

jnev

thank you! newbie here so appreciate the help :)

Paul Newcome

Try putting the AVG(CHILDREN()) on every parent row regardless of level of hierarchy so that it just rolls on up.

jnev

thank you! newbie here so appreciate the help :)

Paul Newcome

Happy to help. 👍️