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
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
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