Calculation Field

[YuChieh]

I need to set a field as calculation field.

If condition1, result 1;

else if condition2, result 2;

else condition 3,4,5..., result 3.

I am not sure if I can use If function, since it can only set two results.

How do I do this?

[Søren Dyhr]

Do you have "Else If" on 6.0??? If you can is it:

If condition1

      result 1

else if condition2

      result 2

else if (condition3 or condition4 or condition5 or ...)

      result 3

end if 

--sd

[YuChieh]

no, I don't see else if in FM 6, which is the problem I have here.

Thanks

[Lee Smith]

That's because it isn't there for calculations, only in scripts.

You will need to create a calculation using a case statement.

Case(Condition=1, 1,

Condition=2, 2, 3)

HTH

Lee