Using `CASE WHEN {type} IN 'Cash Sale' AND 'Invoic...
# suiteanalytics
k
Using
CASE WHEN {type} IN 'Cash Sale' AND 'Invoice' THEN {netamountnotax} ELSE 0 END
&
CASE WHEN {type} IN 'Credit Memo' AND 'Cash Refund' THEN {netamountnotax} ELSE 0 END
This is to get total sales and total returns.