SUM(DISTINCT(CASE WHEN {Transaction.type} = 'Sales...
# general
d
SUM(DISTINCT(CASE WHEN {Transaction.type} = 'Sales Order' THEN {transaction.quantity} else 0 end ))