(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
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
Printer-friendly version
Send to friend
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
Email: PPadmin@planningplanet.com
Replies