% Complete formula
Bjg
✭
Hi,
I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column.
Can anyone help??
Thanks,
Bill
Comments
-
Hi Bill,
Try this out:
ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)
Best,
Kara