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!
I am using a decode formula to separate sales amount by different years, i now want to count the num
I am using a decode formula to separate sales amount by different years, i now want to count the number of customers in that specific year, i need some help
Here is the formula i use to get the sales amount, now i want to count the customers that ordered in 2018, 2019 etc... i cannot return the correct values.
CASE TO_CHAR({trandate},'YYYY') WHEN '2018' THEN decode(to_char({trandate},'YYYY'),2018, NVL({totalamount},0)-NVL({taxtotal},0)-NVL({shippingamount},0)) ELSE 0 END