Formula Help Please

L

Laureen

Hello,

Our vendor set up a formula to measure the schedule. Here is the formula:

IIf([% Complete]=100,9999,IIf(([% Complete]=0 And [Baseline
Start]>Date()),5555,IIf([Baseline Duration]=0,1111,([Duration]-[Baseline
Duration])/[Baseline Duration])))

The problem is that if a project becomes 100% complete, the indicator turns
blue. We want the indicator flag to remain at the true color (according to
where it was when the project finished). We don't want it to turn to "9999"
and then go blue. I thought it would be simple enough to just remove that
part of the formula, but that didn't work. Any ideas would be helpful.

Thanks,
Laureen.
 
J

Jackson T. Cole

Is there some Enterprise Field or Code that could have a value that you
check BEFORE starting the nested conditionals, and if the value means
"Really, really CLOSED", you skip out and change nothing?

FWIW ...

JC
 
Top