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