Skip to content

MS Project Server - Project Interim variance

Stephen GradyMember for 23 years 2 months
Created
3
4
0
I am using MS project Server 2003 and would like to create a variance to calculate the variation between the interim baseline finish (Baseline1 Finish) and the current finish (Finish). I’ve managed to create a formula in a TASK Duration Custom Field using the following formula: ProjDateDiff([Baseline1 Finish],[Finish]) I would like to create the same variance formula as a PROJECT duration to display the project variance in the project Centre in Project Web access. The Custom Field formula I’ve used for TASK Duration does not calculate the variance in PROJECT Duration Custom Field. Can anyone suggest a formula that will calculate Baseline1 Finish v Finish for the project. Thanks Steve

3 replies

Oldest first
  1. 0
    Brian Ultican ·
    In the customize field dialog there is a section called "Calculation for task and group summary rows". In it select "Use Formula". This will have the variance calculated at the summary task levels within your project, including at the project summary task level.

    Remember to use an Enterprise level field if you want this to be calculated for all your projects.
  2. 0
    Stephen Grady ·
    Thanks Brian - that works!

    I must remember to select the "use Formula" option in future.


    Cheers

    Steve
  3. 0
    Brian Ultican ·
    Great.

    Yes it is one of those seetings that slips by many people.

    Cheers

Log in or join to reply

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

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