try:
`CASE WHEN {field1} <> 0 AND {field2} &...
# suiteanalyticsg
garynk
11/29/2017, 11:44 AMtry:
CASE WHEN {field1} <> 0 AND {field2} <> 0 THEN 1 ELSE 0 ENDgarynk
11/29/2017, 11:44 AMCASE WHEN {field1} <> 0 AND {field2} <> 0 THEN 1 ELSE 0 END