script not performing like i think it should

[oilman]

hi all

Have a condition on a script that is acting a little funny. The script is written as follow:

Case[fillet<"4.5",".750",fillet="4.5","1","Unlimited"]

this works fine when fillet is 6.625 or 8 but not when fillet is 10 or 22 or 30 or when the first number is not smaller than 4. what am i doing wrong.

thanks in advance

oilman

[SteveB]

I hope fillet is a number and not a text field cause it won't work as text.

[Keith M. Davie]

And I hope that this "script" really is a calculation, because I can't find "Case" in my copy of ScriptMaker.

[IdealData]

Also consider what is the data type for the result field.

You appear to be mixing text and numbers as your default result is "Unlimited", but you seem to be implying the use of numbers otherwise.

[oilman]

Thanks for the information - got it to work

oilman