How to attain an average to the lowest level hierarchy
I'm trying to attain a formula that would provide an average of the lowest level of children in a hierarchy. Currently I'm using a =AVG(CHILDREN()) formula, but based on the amount of data we are collecting, the highest most level of hierarchy is beginning to vary significantly based on the fact it is only capturing the average of it's children at the first level vs. what the average should be at the lowest level. I've attempted to manipulate it using AVERAGEIF formulas and IF formulas, but can't seem to get this one worked out.
Help Article Resources
Check out the Formula Handbook template!