Need a Formula that only applies to Parent rows
I am trying to figure out a formula that will only apply to parent rows. I want the Parent % complete to calculate on the total percentage of all child rows. The embedded formula depends on a duration, and I do not want that.
The current formula I have is this:
=IF((COUNT(CHILDREN([email protected])) > 0),AVG((CHILDREN([% Complete]@row))),([% Complete]@row))
I'm not sure what the second part of my if statement should be, since I want it to be whatever % has been entered for the Child row.
I was hoping to also make this a column formula to apply to all rows, but not sure if that is possible.