% 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

Kara Lumley

Hi Bill,

Try this out:

ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)

Best,

Kara