IF statement not working

[tushar44]

Hi there,

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

[Qiu · Accepted solution]

@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]

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.