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
Solved! Go to 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.
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.
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 : )