if that syntax doesn't work you can always do `CAS...
# suiteanalytics
a
if that syntax doesn't work you can always do
CASE WHEN ({tranid} = 'ID1' OR {tranid} = 'ID2' OR {tranid} = 'ID3' OR...) THEN 1 ELSE 0 END