Skip to content
ProjectControls.com
Microsoft Project

Planned % Complete Column - Nothing is Working :-(

In the Open Standard
Rowena BeatonMember for 16 years 3 months
Created
1
3
0

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

 

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Tom Boyle ·
    #1

    Hi Rowena,Have you tried

    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

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?