Formula on Grand Parents row
Please I do not know what I am doing wrong with my formula on % complete column, I have intention of calculating average on a grand parent 'the first row' which has other parents as indent.
I used the formula
=AVG(CHILDREN([Days to due Date]@row))
It is giving me above 1000%. please what do I do?
Ps: I do not know if the formula is appropriate. It is the same I used on parent rows and it works well.
Help Article Resources
Check out the Formula Handbook template!