OR logical function

[Anonymous]

Is there an equivelent to the OR logical function?

Im trying to load a flag as to whether or not one field is equal to any of 3 seperate values.

If(X = 'a' or 'b' or 'c',1,0)as Flag, returns true for every record including those that = d, e, f, etc.

[erichshiino · Accepted solution]

did you try to repeat the field on the conditon?

If(X = 'a' or X = 'b' or X = 'c',1,0)as Flag

[Anonymous]

thanks.

[Anonymous]

Same thing, different approach, I prefer it as a more flexible:

if(match(X,'a','b','c'),1,0)