When a saved search with summarised data is used in reminders, only 0 is displayed instead of the total number of rows available in the search itself. How real numbers can be shown in reminders

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that the issue of reminders showing '0' instead of the actual count of results from a summary saved search is a known limitation in NetSuite. The reminder is showing you the number of total records, ignoring the summary. One workaround suggested is to add the internal ID to the results of the search and do the summary type Count for it. However, this may not always work and depends on the type of search you have. Another suggestion is to use the NVL function to wrap your values, like

NVL(yourfield,0)

. This function will return the value of

yourfield

if it is not null, otherwise, it will return '0'. If these workarounds do not work, you may need to create a search that returns only the number of results you want to show in the reminder. In the results of this search, you can have it link to a different details search so you get the best of both. Alternatively, you can instruct your team to add the saved search as a portlet on their dashboard, which may provide a more accurate count of the results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******