Formula doesn't work as a enterprise field

[John Simko]

I have created the following formula that displays a stoplight indicator
depending on the status of a planned work relative to baselined work.

IIf([Baseline Cost]=0,0,(IIf([Cost]=0,1,IIf([Cost]<=([Baseline
Cost]*1.2),IIf([Cost]<=([Baseline Cost]),1,2),3))))

The formula works fine if I create a custom field in a project, however, if
I make it an enteprise field and display it in a project it doesn't work. I
get #ERROR. Please help me understand why this is happening and if there is
something I can do to fix it.

Thanks,

John

 

[John Simko]

Never mind. It works fine once I manually recalculate.

Thanks,

John

 

[Dale Howard [MVP]]

John --

Have you considered using the Switch function instead of the nested If
statements? Just a thought to simplify the formula.

Never mind. It works fine once I manually recalculate.

Thanks,

John

I have created the following formula that displays a stoplight indicator
depending on the status of a planned work relative to baselined work.

IIf([Baseline Cost]=0,0,(IIf([Cost]=0,1,IIf([Cost]<=([Baseline
Cost]*1.2),IIf([Cost]<=([Baseline Cost]),1,2),3))))

The formula works fine if I create a custom field in a project, however,
if
I make it an enteprise field and display it in a project it doesn't work.
I
get #ERROR. Please help me understand why this is happening and if there
is
something I can do to fix it.

Thanks,

John