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!
Defaulting to 0 when no result
I have a transaction saved search, which sums daily transaction counts, ie.
Date: Group
Document Number: Count
This works fine, but excludes days when there is no result. We'd like to be able to paste a date range into Excel, but can't do so, as the days with no results are generally weekends, which obviously fall on different dates each year.
Can anyone suggest how I can get the search to include a date and 0 when there are no results for that day?