Custom Task Progress Indicator does not work if baseline changes

[Uttkarsh Kalia]

Hi,
I am using EPM 2007 environment. I have created Task Progress custom
indicator field at task level. The issue is when I change the baseline from
Baseline to Baseline1 the indicator shows blank in the field. If I
re-baseline on the default baseline it shows the indicators. I want the
formula should work when baseline is changed to new baseline.

IIf(len(Cstr([Project Baseline Check]))<3,"No Baseline",IIf([%
Complete]=100,IIf([Finish Variance]>0,"Late Completion",IIf([Finish
Variance]<0,"Early Completion","Completed")),IIf(ProjDateDiff([Current
Date],[Baseline Start])/480>0 And [% Complete]=0,"Not
Started",IIf(ProjDateDiff([Baseline Finish],[Current Date])/480>0,"Late","On
Time"))))

Is my formula wrong?

Any help will be appreciated

Thanks in advance!

 

[Dale Howard [MVP]]

Uttkarsha --

I believe your error is not in the formula, but in how you use the alternate
Baseline sets of fields. My recommendation is that the Baseline set of
fields should always contain the current baseline information for the
project. This is because all variance in a project is always calculated
using the Baseline set of fields. If you need to rebaseline a project in
its entirety, I recommend that you back up the current baseline information
into one of the alternate Baseline set of fields, such as in Baseline 1, for
example. And then you can rebaseline the entire project, knowing that you
have a backup copy of the original Baseline information for historical
purposes. Hope this helps.