IF Statement for numbers to text

Question

Hello Community,

I  hope that you're all well.

I have a data set that I need to create a filter on, but I am not having any luck.  I used the Select Tool to change the data type to V_String from Double.  I have also used the ToNumber syntax and I am still missing the target.

I am sure it's something mundane that I am missing.

Thank you for your time and help in advance!

Fescobar

Cases on Hand.xlsx

Cases on Hand.yxmd

chuckleswk · Accepted Answer

You need to create a new field in your formula tool that is a string variable. The reason you're throwing an error is because 10+ is a string and not a number.

chuckleswk · Accepted Answer

Alternatively, you can change the "Cases on Hand" to a string field with a select but you need to add another "ToNumber" on your second "[Cases on Hand]" in your If Statement.

atcodedog05 · Accepted Answer

Hi @Fescobar

You need to use select before to change Cases on Hand to V_string and add ToNumber in the below highlighted place.

Workflow:

Hope this helps : )