IF statement for non whole numbers

[richleeb2]

How do I write an IF statement in the formula tool that says IF a field is not a whole number, then the message will read "..." in the new column?

[ARussell34]

If your numbers are currently an integer, i.e. int32 or int64, use a select tool to change that column type of your number to a double.

If you have your number type as a double (decimals included) currently, then you could use a formula tool to say

If contains([number], ".") then "..."

else "whole"

endif

[DataNath]

Hey @richleeb2, there's an IsInteger() check within Alteryx that we can use here. I don't know what you wanted to output if the record is a whole number but I've just output the number itself in that case (you can obviously change this):

[Luke_C · Accepted solution]

Hi @richleeb2 

The IsInteger() function has you covered:

[richleeb2]

This worked!  But how do I get it to ignore null values?

[Luke_C]

Hi @richleeb2 

From my testing my formula should already ignore null values, perhaps you can share what your expected results are in that case?

[richleeb2]

Value	Result
null
Hi	Must be a whole number
1.2	Must be a whole number
3
1.5	Must be a whole number

So if the Value field is either blank, null or a whole number, then nothing should show in Result column.  Otherwise, I want it to show "Must be a whole number"

[Luke_C]

Hi @richleeb2 

Update the ... in my example to "Must be a whole number" and youll have what you need.