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

Workflow

Accepted answers

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,

All comments

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.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703