`CASE WHEN {amount} = NULL THEN 0 WHEN {amount} = ...
# suiteanalytics
j
CASE WHEN {amount} = NULL THEN 0 WHEN {amount} = '' THEN 0 ELSE {amount} END