@ Julia it sounds like you need something like CAS...
# suiteanalytics
a
@ Julia it sounds like you need something like CASE WHEN (what you want to pull from THEN {amount} ELSE 0 END