Formula syntax error

[kdnichols]

Hello All,

I am having problems with this syntax in Cyrstal 10 Formula editor:

If {ORDER_MV.O_CAT_TYPE} in ('TS')
and {ORDER_MV.OM_REPORT_GSV} >=1 Then
{ORDER_MV.OM_REPORT_GSV};

I want it to display the results of {ORDER_MV.OM_REPORT_GSV} when the condition in the IF statement is met.

Any help is greatly appreciated. What am I doing wrong here?

Thanks,

Kurt

 

[Kempes]

you don't need the in ('TS') part.

You could change that to = "TS"

 

[Mile-O]

But, for reference, when using In, make sure the criteria is in square brackets. i.e. .. In ["TS","UB"]

 

[kdnichols]

Thanks

Hello Milo,

Thanks that worked.

Can you take a look at my new question?

Again many thanks!

Have a great day!

Kurt