It sounds a lot like what a user gets when they type in a search text in a search box against all fields... they will see every data value in every field in the whole data model that matches their typed in value .
Otherwise to check if the inputed string is in ANY of the data values for a given field you can try concat( distinct ) to check. Modified sample as follows...
if ( substringcount( concat( distinct [FieldName] ,';') , $(vVariableName) ) > 0 , ..compare with sales..., null())
for the 'compare with sales' you would need a nested IF statement to select other fields, but that could get slow and inefficient.
.png "Former Employee"){kind=icon}
