Skip to content

Current Baseline - Between set periods

Craig AdamsMember for 20 years
Created
2
4
0

Hello Fellow Asta Travellers,

Would like to create two columns that show specifiic baseline periods from the same baseline - for instance baseline finish dates for year ending 2011 then another column showing 2011 to year ending 2012 out of the same baseline.

Yes could create two baselines however trying to use only one for original baseline (budgeted works) and one for "what if scenarios".

Can anyone help with formula for this?

Look forward to your reply/ies.

Kind regards,

Craig adams

2 replies

Oldest first
  1. 0
    Mike Testro ·

    Hi Craig If you have the two

    Hi Craig

    If you have the two baselines open in the view then in table definition you can set up two "Finish" columns - give them a name to suit your baselines.

    In the right hand dialogue box under "Data" you can select which of the baselines to display.

    Unfortunately the time slice option is greyed out.

    Best regards

    Mike Testro

  2. 0
    Andrew Willard ·

    Hi Craig, If I understand you

    Hi Craig,

     

    If I understand you correctly these two forumals do the trick;

     

    For 2011

     

    Switch(Task[~CB].Finish >= '1/1/2011' and Task[~CB].Finish <= '31/12/2011', Task[~CB].Finish)

     

    and for 2012

     

    Switch(Task[~CB].Finish >= '1/1/2012' and Task[~CB].Finish <= '31/12/2012', Task[~CB].Finish)

     

    Cheers

     

    Andrew

     

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?