Problems with calculation for task and group summary rows

[Shaun]

I am trying to average out all of the tasks; and this works great. The
problem that I have is once I am done with a task I would like it not to take
the task into account. I am using this formula IIf([% Work
Complete]=100,0,ProjDateDiff([Finish],now(),[Project Calendar])) in a number
field to obtain a value. So I am using 0 as the value to return if complete.
The problem is that if I have 8 tasks in a group it takes the total and
averages it out accosts all 8 tasks. If I make 2 of the tasks complete I
would like it to sum it and then averages it out accost the 6 remaining tasks.

Any help would be greatly appreciated!

 

[Jack Dahlgren]

Use another custom field.
Set the value to 1 for the tasks you want to use.
Use a custom field which divides the sum of the task values and then divide
by the sum of the first custom field.
If you want something different, this same technique can get you there.

-Jack