You could try CASE WHEN {FIELD} LIKE '%VALUE%' THE...
# suiteanalytics
k
You could try CASE WHEN {FIELD} LIKE '%VALUE%' THEN 1 ELSE 0 END