Why is my formula giving me incorrect average when trying to average the children rows?
I have a formula that is averaging the percentage of the children row of the column Percent completed, to give me another percentage of the ones that are less than 100% and then I have another column that will average the percentage of the ones that are greater than 100%. But it is not giving me a correct percentage. The screen shot should average 75% in the Goal Not Met column but it's returning as 59%. Is there something I need to change in my formula?
Help Article Resources
Check out the Formula Handbook template!