IF Statement for numbers to text

[Fescobar]

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

[chuckleswk · Accepted solution]

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 solution]

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 solution]

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 : )