D
Dale
I have a formula in a custom field, that shows the following.
IIf([Baseline Finish]>#1/1/2900#,-9,9,IIf([Baseline Duration]=0,[Finish
Variance]/[Enterprise Project Number2,],[Finish Variance]/[Baseline
Duration]))
The formula above does not show 999 or 25.
The correct formula is
IIf([Baseline Finish]>#1/1/2900#,-999,IIf([Baseline Duration]=0,[Finish
Variance]/[Enterprise Project Number25],[Finish Variance]/[Baseline
Duration]))
I get the correct result from the formula, but can not understand why after
editing and resaving, when I view the formula readonly or checkout the
Enterprise global I get the incorrect formula showing. I have checked this
from a pc running XP and 2000, both clients using Project 2003 SP1.
IIf([Baseline Finish]>#1/1/2900#,-9,9,IIf([Baseline Duration]=0,[Finish
Variance]/[Enterprise Project Number2,],[Finish Variance]/[Baseline
Duration]))
The formula above does not show 999 or 25.
The correct formula is
IIf([Baseline Finish]>#1/1/2900#,-999,IIf([Baseline Duration]=0,[Finish
Variance]/[Enterprise Project Number25],[Finish Variance]/[Baseline
Duration]))
I get the correct result from the formula, but can not understand why after
editing and resaving, when I view the formula readonly or checkout the
Enterprise global I get the incorrect formula showing. I have checked this
from a pc running XP and 2000, both clients using Project 2003 SP1.