CASE WHEN (SUM(CASE WHEN {type} = 'Invoice' THEN {...
# suitescript
b
CASE WHEN (SUM(CASE WHEN {type} = 'Invoice' THEN {amount} ELSE WHEN {type} = 'Sales Order' THEN (-1 * {amount}) ELSE 0 END)) > 0 THEN 'Great!' ELSE 'Not Great!'