SUM(CASE WHEN {type} = any('Credit Memo', 'Cash Refund') THEN NVL({netamountnotax},0) ELSE 0 END/CASE WHEN {type} = any('Cash Sale', 'Invoice') THEN NVL({netamountnotax},0) ELSE 0 END)*100