Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

IF statement not working

tushar44
6 - Meteoroid

Hi there,

 

Please take a look at this workflow and help me identify what's the problem here in this IF formula. Thanks!

 

tushar44_0-1615376517839.png

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@tushar44 
Most likely, your[DateSet Type] column is not a Numeric Type, Try to use a Select to change it to Int or Int16.

pedrodrfaria
13 - Pulsar

Hi @tushar44 

 

Just to complement what Qiu mentioned, which I believe to be correct.

 

When applying a numeric function to a string value, the formula tool will flag like everything is okay until the last error, so this is why you have colors above and only flagging the last instance of the error as an error.

 

Just change the column data type to be a numeric and you will be all set. 

 

I attached couple of pictures to explain, for illustration. 

 

pedrodrfaria_0-1615378506112.pngpedrodrfaria_1-1615378522676.png

 

Labels