IF Statement

[Kinetic_analytics]

Hello:

How can I formulate an If isNull statement with (- OR  . OR 0000 OR 00000)  then missing else good these four elements.

Thanks

[Thableaus · Accepted solution]

Hi @Kinetic_analytics 

Try something like IF IsNull([Field]) OR [Field] IN ('-', '.', '0000', '00000') THEN....

The IN clause is easier to read in my opinion, and you can consolidate multiple OR expressions in one set of parenthesis.

Cheers,

[Kinetic_analytics]

Thanks :) it works. Appreciate your help in my learning process.