Hey! Can anyone help with this? I am clueless when it comes to using formulas in NetSuite... How would I edit this formula to include cash sales and credit memos? I need it to add the QTY from all invoices and cash sales, then subject the qty from credit memos. CASE WHEN {transaction.trandate} between add_months({today},-n) and {today} and {transaction.type}='*Invoice*' then {transaction.quantity} end

CASE WHEN {transaction.trandate} between add_months({today},-n) and {today} and {transaction.type} in('Invoice', 'Cash Sale', 'Credit Memo') then {transaction.quantity} end