newbie: please help - if/elseif error message

[dbudman]

why am i getting this error message? thank you so much. have a nice weeke

[PanPP]

Hi @dbudman 

You will need to make sure the value inside the quotes is also the correct data type to fit the expression.

then you will need to change null() to isnull() and this should resolve your issue.

[dbudman]

hi thanks just did that but didn't work :(

[PanPP]

Can you replace isnull() to ""    it will output a blank column which is essentially the same thing.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

[binu_acs]

@dbudman seems to be a data type issue for the field , please make sure that the field Median income (dollars) is numeric 

[ShankerV · Accepted solution]

Hi @dbudman 

The problem is due the data type mismatch of the incoming column Median Income (dollars).

Your IF/ELSE is erroring because of the incoming data type as below.

Use SELECT TOOL before your formula tool and just change the datatype to Int64. Your existing formula will work.

Many thanks

Shanker V

[dbudman]

thank you so much!