Average % Complete If another Column is Checked
I am trying to get the % Complete for a project by averaging the Project Phases % Complete(which are parents to tasks).
- =AVG([% Complete]:[Project Phase], 1) I used this formula to only calculate the values in the row that has been identified as a Project Phase with a check.
- Answer is 8.39
- =AVG(CHILDREN()) * 100 - These are the values that are calculated for the Project Phase
- Calculating by hand I get 110/5=22
Please explain how the formula is working (curious) and what is the correct formula to average my project phase %complete to get an estimation of project %complete.