Anything over 1000000 gets an incorrect code

Morning work family!
I am working on a formula and running into a problem. I am trying to code houses over $500000 with a 2 in a new column, and under with a 1 (unknowns with 0). It works fine until I run into a house over $1000000, in which it gives it a code of 1 instead of 2. I am assuming I need to do something that pushes everything to the right to analyze it, but 1)I'm not sure and 2)I don't know how to do that. Here is what I have:

IF IsEmpty([Estimated Current Home Value]) THEN "0" ELSEIF [Estimated Current Home Value] > "500000" THEN "2" ELSE "1" ENDIF

Any ideas on how I can get this fixed?

Thanks,
Terri

Common Use Cases

Accepted answers

RolandSchubert

Hi @tpostlewate ,

you could convert to value in the column to number to ensure, that the numeric value is used in the condition and not the string value. Give this condition a try:

IF IsEmpty([Estimated Current Home Value]) THEN
"0"
ELSEIF ToNumber([Estimated Current Home Value]) > 500000 THEN

"2"
ELSE
"1"
ENDIF

Let me know if it works for you.

Best,

Roland

All comments

FlorianC

Hi @tpostlewate,

The formula you shared is comparing the text value of the field [Estimated Current Home Value] to the text value "500000".

In order to properly check for the amount value, convert the field [Estimated Current Home Value] to an integer or double and remove the quotes in your formula to compare numbers together.

RolandSchubert

Hi @tpostlewate ,

you could convert to value in the column to number to ensure, that the numeric value is used in the condition and not the string value. Give this condition a try:

IF IsEmpty([Estimated Current Home Value]) THEN
"0"
ELSEIF ToNumber([Estimated Current Home Value]) > 500000 THEN

"2"
ELSE
"1"
ENDIF

Let me know if it works for you.

Best,

Roland

tpostlewate

Thank you! That worked perfectly.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703