Customise Fields- Enterprise Global

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dale (Dale_at_discussions.microsoft.com)
Date: 01/06/05


Date: Thu, 6 Jan 2005 08:35:02 -0800

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.