I have created `SUM(CASE WHEN {type} IN 'Credit Me...
# suiteanalytics
k
I have created
SUM(CASE WHEN {type} IN 'Credit Memo' AND 'Cash Refund' THEN {netamountnotax} ELSE 0 END/CASE WHEN {type} IN 'Cash Sale' AND 'Invoice' THEN {netamountnotax} ELSE 0 END)*100
but doesnt want to work.