Planned % Complete Column - Nothing is Working :-(

Member for

18 years 11 months

Hi Rowena,

Have you tried something like this formula in a custom number field - say "%Comp Planned"?

IIf([Baseline Cost]>0,[BCWS]/[Baseline Cost],0)*100

Be sure that "Use fomula" is selected in the Calculation for task and group summary rows.

BCWS (Budgeted/Baseline Cost of Work Scheduled) is the planned value to have been achieved by the Project Status Date.  Dividing by the Baseline Cost gives the planned %Complete.

Good luck, tom