If that doesn't work `CASE WHEN {amount} = NULL TH...
# suiteanalytics
j
If that doesn't work
CASE WHEN {amount} = NULL THEN 0 ELSE {amount} END