In a selection formula, I use the "IN" operator to select data based on text string existing in a field
<text variable> in <field>
but i also want to select the data when <text variable> does not exist in the field.
How do I incorporate Not into the formula so I only select data when a <text variable> is not in the <field>?
<text variable> in <field>
but i also want to select the data when <text variable> does not exist in the field.
How do I incorporate Not into the formula so I only select data when a <text variable> is not in the <field>?