Hi there,
Please take a look at this workflow and help me identify what's the problem here in this IF formula. Thanks!
Solved! Go to 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.
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.