Indicator with Multiple Baseline

C

CQ

I want to make an on-time indicator that uses the start date against the MOST
RECENT baseline. In other words, I will always have projects with at least
one baseline but some of them may have 2 or 3 or 4 and in those cases, I want
to compare the fourth baseline's start date against the actual start date for
that task. The question is: How do I write a formula to account for
possible baselines?
 
G

Gary L. Chefetz [MVP]

You can't do this using a formula. First, you need to use the project object
to determine the baseline save dates as these are properties and not
readable data fields. In order to use the object model, you need Project
running and the project open. How are your programming skills?
 
V

Victor

Maybe I misunderstood the original posting, but couldn't you do a
formula using the IIF statement?

Here is an example for a budget indicator:

IIf([Baseline3 Cost]=0,IIf([Baseline2 Cost]=0,IIf([Baseline1
Cost]=0,IIf([Baseline Cost]=0,0,([Cost]-[Baseline Cost])/[Baseline
Cost]*100),([Cost]-[Baseline1 Cost])/[Baseline1
Cost]*100),([Cost]-[Baseline2 Cost])/[Baseline2
Cost]*100),([Cost]-[Baseline3 Cost])/[Baseline3 Cost]*100)


When doing a schedule indicator you would check for N/A instead of 0 as

in the following code snipet:

IIf([Baseline3 Finish]=ProjDateValue("NA"),II­f([Baseline2
Finish]=ProjDateValue("NA") .....

Thanks,

Victor
 
G

Gary L. Chefetz [MVP]

Victor:

It can work if the baselines are used in a predictable structured order and
the number saved never exceeds the 11 available.




Maybe I misunderstood the original posting, but couldn't you do a
formula using the IIF statement?

Here is an example for a budget indicator:

IIf([Baseline3 Cost]=0,IIf([Baseline2 Cost]=0,IIf([Baseline1
Cost]=0,IIf([Baseline Cost]=0,0,([Cost]-[Baseline Cost])/[Baseline
Cost]*100),([Cost]-[Baseline1 Cost])/[Baseline1
Cost]*100),([Cost]-[Baseline2 Cost])/[Baseline2
Cost]*100),([Cost]-[Baseline3 Cost])/[Baseline3 Cost]*100)


When doing a schedule indicator you would check for N/A instead of 0 as

in the following code snipet:

IIf([Baseline3 Finish]=ProjDateValue("NA"),II­f([Baseline2
Finish]=ProjDateValue("NA") .....

Thanks,

Victor
 
C

CQ

Thanks for the advice. I think I will try Victor's solution first and then
tackle the programming method if that doesn't work. I guess I have to make
sure that I have a solid business rule about order of saving of the baselines
though! Thanks again.
 
Top