I am trying to create a field that completes a simple IF function. Here is the formula currently: IF(Field1 ≥ "1320"; "Y"; "N").
The field does correctly identify all records that are greater than or equal to 1320, but for some reason, the field is marking "Y" for some, but not all records, that have values less than 1320. Field1 is an indexed number field.
Does anyone know what could possibly be causing this problem? Did I miss a step somewhere?
I would appreciate any help/suggestions!