Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

If Then Statement producing some inaccurate outputs

awhitehead012
7 - Meteor

The If Then statement is suppose to output the Length of Assignment in days. Any value between 0 and 365 days is to output 1 into the 1 or 2 column. Otherwise all other values are suppose to indicate 2 in the 1 or 2 column. 

 

There are values in Length of assignment that are over 1000 and indicating 1 when it should be 2. 

 

I need some help figuring out why the values are returning the wrong output. 

 

 

 

10 REPLIES 10
Qiu
21 - Polaris
21 - Polaris

@awhitehead012 
It is nice that you want to understand.
I can still see the "" in your latest screen shot...
If you can upload your workflow, I can take a look also.

The formula should be looking like below.
The location of "(" and ")" are also important.

 

If tonumber([Length of Assignment]) >= 0 AND  tonumber([Length of Assignment]) <= 365 then 1 else 2 endif 

 

Labels