Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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?
0