% Complete Calculation

KBeem

Is there a way to exclude tasks/rows from the % Complete Calculation?

Paul Newcome

Yes. You would use a COLLECT function (or SUMIFS or AVERAGEIF depending on your setup) within your formula used to generate the % Complete to specify which rows to INCLUDE. You will need to be able to specify some kind of identifier in the formula for it to compare against unless you wanted to create a long, tedious, rigid, manual formula.