saved search "show totals" does not return the cor...
# ask-stanley-ai
j
saved search "show totals" does not return the correct amount. exporting and summing shows gives the correct result.
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that the "Show Totals" option in NetSuite's saved search behaves differently depending on whether the search is grouped or not. For non-grouped searches, the "Show Totals" option works as expected. If it's unchecked, the total line will not be included in the exported CSV file. However, for grouped searches, the "Show Totals" option only applies to the drill-down version of the grouped saved search. Even if "Show Totals" is unchecked, a total line will still be included in the exported CSV file. This is standard behavior in NetSuite and there doesn't seem to be a global setting that overrides this. One workaround suggested in the conversations is to change the summary type of the values that are summed to Max or Min. For example, if you have a search with two columns, where the first column is grouped and the second column is summed, changing the summary type of the second column to Max or Min and using a formula to sum the values will remove the total row. Another issue discussed in the conversations is a discrepancy in the total quantity when the saved search results are emailed as a CSV. This might be due to the 'Summary Type' setting in the saved search. When set to 'Sum', NetSuite sums up all the records that have the same characteristics. However, when the results are emailed as a CSV, the 'Summary Type' setting may not apply, and each individual record is listed separately, causing the total quantity to be a multiple of the original amount. A potential solution is to adjust the saved search to not use summary fields, but instead use a formula field to calculate the difference on each line. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.860290587
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848388791
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.846496642
Please provide your feedback on this answer.