how about `CASE WHEN {type} = any('Cash Sale', 'In...
# suiteanalytics
k
how about
CASE WHEN {type} = any('Cash Sale', 'Invoice') THEN {netamountnotax} ELSE 0 END