Dear All,
I am working with MS Project 2010. My calender is 24hr working 7 days a week.
I need to show a column which highlights the planned % complete for a given status date.
This is so we can present to our client (for example) - we should be 40% complete through today but we are only 30% because of XXXX
I am also using an S Curve based on cumulative vs actual manhours.
My plan has been baselined. I have tried a few formulas online but after 6hrs today I am struggling to get one that works!
Can anyone help?
Very much appreciated!
Thank you in advance for your time.
Best Wishes
RB
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