Maybe there's a space? Or a hidden character. Try ...
# suiteanalyticsj
jcribb
03/06/2018, 12:51 PMMaybe there's a space? Or a hidden character. Try
CASE WHEN {amount} = NULL THEN 0 WHEN {amount} = ' ' THEN 0 ELSE {amount} END