#divide by zero error

Allin

I'm trying to create a column formula, but i get divide by zero error in the parent cell. I want the parent cell to be blank, but the formula will populate an answer in the children row. Is that possible? Formula is =AVG([Sep 2022]@row:[Dec 2022]@row)

Jeff Reisman

@Allin You can throw an IFERROR in front of the formula that will stifle error messages:

=IFERROR(AVG([Sep 2022]@row:[Dec 2022]@row), "")

or you can prevent errors altogether by restricting this to child rows:

=IF(COUNT(ANCESTORS()) > 0, AVG([Sep 2022]@row:[Dec 2022]@row))

This will only run the formula if the row has ancestors, meaning it's not a parent row. You can increase the number value in the count part of the formula if your parent rows are lower down in the hierarchy.