Check if numeric column is all integers or all decimals

[dpakapd]

Hi,

I have a sales amount column in my data where the numbers are all supposed to be integers or all supposed to be decimals. However they are not supposed to be mixed, i.e. it cannot be 145, 234, 14.57, 32. 

How can I add a column (using formula tool or similar) to say "NUM ERROR" when the sales amount column is mixed?

I wrote 2 multi-row formulas for catching integers and decimals. But ultimately I want only one column that shows "error" if an only if the sales amount column has mixed data (integers and decimals).

Can you pl advise how I can achieve this?

Thanks

[atcodedog05 · Accepted solution]

Hi @dpakapd 

Here is how you can do it.

Workflow:

Hope this helps : )

[dpakapd]

@atcodedog05 : This really helped! Thank you so much!

[atcodedog05]

Happy to help : ) @dpakapd 

Cheers and have a nice day!