Formula component - OR

[Alex_A]

HI, I am trying to use an OR operator with a field formula i.e. - IF [SDLNTY]="CN,DN" THEN 0 ELSE [SDSOQS] ENDIF = So if the reference column(SDLNTY) contains the string CN Or the string DN then the new field value should be 0 Otherwise it should show SDSOQS column.

I'm guessing this should be fairly straightforward but I wasn't able to find it out so far.

Appreciate the help!

[vishwa_0308 · Accepted solution]

Please try this :

IF [SDLNTY] in ("CN","DN") THEN "0" ELSE [SDSOQS] ENDIF

Vishwa