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!
Number of orders shipped per day
Hi, I am trying to have a field that counts the number of item fulfillment that have shipped between a given date and divides by the number of days in that month. This is what I have but I keep getting errors. Is this even possible?
Formula Numeric | Summary Type Sum |
COUNT(DISTINCT(CASE WHEN {systemnotes.date} between TO_DATE('01/01/2014', 'mm.dd.yyyy') AND TO_DATE('12/31/2014', 'mm.dd.yyyy') then {number} end))/(TO_CHAR((last_day({systemnotes.date})),'DD'))
Thanks!