conditional failing

HI there,

Not sure what is wrong with my conditions statement(?)

IF 0.97 <= [AVG] >= 1.03
THEN 0
ELSE 1
ENDIF

while running the workflow I am getting the following error (see attached PNG file). Can someone please quickly take a look?

Thanks,

Azad

Expression

Accepted answers

@AZAD Is AVG perhaps a string? You can check by clicking on the line entering the formula tool. I would use a tonumber function to convert it:

IF 0.97 <= tonumber([AVG])  AND tonumber([AVG]) >= 1.03
THEN 0
ELSE 1
ENDIF

You'll also want to change this calculated field to a numeric type (like int16 or double).

@AZAD I'm not as familiar with the logistic tool in Alteryx. I would start a new thread.

@AZAD try this:

IF 0.97 <= [AVG]  AND [AVG] >= 1.03
THEN 0
ELSE 1
ENDIF

Same error.

Same error.

@AZAD Is AVG perhaps a string? You can check by clicking on the line entering the formula tool. I would use a tonumber function to convert it:

IF 0.97 <= tonumber([AVG])  AND tonumber([AVG]) >= 1.03
THEN 0
ELSE 1
ENDIF

You'll also want to change this calculated field to a numeric type (like int16 or double).

Oh yeah. I totally missed to checkout the datatype.

Thanks, Patrick. Appreciate it.