Customise Fields- Enterprise Global

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.
 
D

Dale

I changed the locale from English UK to English US and can now the display is
correct....

I know that MS did have not supplied a UK locale, so this could be the
problem. Does any one know of a workaround / fix / patch that is available.

thx

Dale
.....................................................
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top