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??
Try this out:
ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)