case when SUM ( case when {type} = 'Invoice' th...
# suitescript
a
case when SUM ( case when {type} = 'Invoice' then {amount} else 0 end ) > 1000 then 'Good Job' else 'Totes Fired' end