Parse Error at Char (67): Formula tried to apply numeric operator to string value

[annieskogen]

Hi, I was wondering if someone could help with the error in this formula:

if [END_INV_QTY] < [Targeted Inventory] then 0 else [END_INV_QTY] - [Targeted Inventory] endif

I'm getting the following error (Parse Error at Char (67): Formula tried to apply numeric operator to string value) and the color is stopping at the last [Targeted Inventory] endif

[Luke_C]

Hi @annieskogen 

Check the data types for each of these fields using a select tool before the formula tool. It sounds like one of these may be a string field instead of numeric (i.e. double, integer, etc)

[Qiu]

@annieskogen 
Char (67) is the location of field [Targeted Inventory] so please make sure it is a numerical field.

[TUSHAR050392]

One of the column that you are using is String. Try using a select tool and change the data type of that string field to number and then the formula should work