BaseLine and Formula

S

Shilpa Gupta

I have created Budget and schedule indicators. The formulas use
Baseline 0(or baseline 1 or baseline 2..) values for the calculations.
But a project may have more than one baseline. I actually want the most
recently saved baseline values to be used to calculate the budget and
schedule indicators.
Any Ideas what can be done.
 
V

Victor

You could 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"),IIf([Baseline2
Finish]=ProjDateValue("NA") .....

Hope that helps.

Victor
 
Top