Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Formula Help
I am trying to use the formula below, but keep getting an invalid expression error. I'm not sure what I am doing wrong. It works if I remove the transaction date section, but when I put it back in it fails.
case when {transaction.trandate}>LAST_DAY({today},-1) and {transaction.type}='Cash Refund' or {transaction.type}='Cash Sale' or {transaction.type}='Credit Memo' or {transaction.type}='Customer Refund' or {transaction.type}='Invoice' then {transaction.amount} else 0 end