Try `CASE {amount} WHEN NULL THEN 0 ELSE {amount} ...
# suiteanalyticsj
jcribb
03/06/2018, 12:37 PMTry
CASE {amount} WHEN NULL THEN 0 ELSE {amount} ENDjcribb
03/06/2018, 12:37 PMCASE {amount} WHEN NULL THEN 0 ELSE {amount} END