I have a saved search where tryin to mimic this formula. CASE WHEN {transaction.type} = 'Sales Order' AND ({transaction.status.id} NOT IN ('fullyBilled','cancelled','pendingBilling','closed')) THEN {transaction.quantity} ELSE 0 END The criteria for the saved search included in the img: