Another Malformed if Statement

[JeffVTR]

Hi 

I'm having issues with an if statement and I know it is the highlighted lines. Can anyone please show me what I'm doing wrong? 

[ShankerV]

Hi @JeffVTR 

The problem is here.

Where you have initially created OR correctly but on the remaining you have used 2 or 3.

Kindly change to [Moving code] = 2 or [Moving code] = 3.

Many thanks

Shanker V

[DataNath · Accepted solution]

Hey @JeffVTR, I actually wrote a blog post on common Formula tool errors which I believe ought to cover the issues here!

https://community.alteryx.com/t5/Engine-Works/Troubleshooting-Common-Formula-Expression-Errors/ba-p/...

In particular I’d check the fields you’re checking the numeric value for I.e. [Moving Code] are the correct (numeric) data type. Also, where you use ‘OR’, you need to define the field again i.e. [Field] = ‘A’ OR [Field] = ‘B’. Take a look at the section about AND/OR statements not returning the correct results as well because your current syntax will need bracketing too.

[JeffVTR]

@DataNath you nailed it in your blog. I searched high and low for something like that and could not find anything on OR being used in IF statements.

To summarise, I needed to replicate the text that @ShankerV pointed out and add parentheses to the statement. 

You saved my computer monitor @DataNath!