I'm using a summary type to sum different group ty...
# ask-stanley-ai
a
I'm using a summary type to sum different group types in a saved search. The total is showing on a saved search sublist but I don't want it to. I have unchecked 'Show Totals' on the saved search. How can I remove the total from showing?
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that the total row in a summarized saved search in NetSuite is automatically included when the summary type is set to 'Sum'. However, there is a workaround to remove the total row. You can change the summary type from 'Sum' to 'Max' or 'Min'. This will remove the total row from the saved search. If you still need to have a sum value, you can create a Formula (numeric) and then do SUM({fieldvalue}) then summary of MAX. This will give you the same sum value but without the total row. Here's an example: If you have a search with 2 columns: Column 1: Customer: summary type = group Column 2: Amount: summary type = Sum This will show a total row. However, if you change it to: Column 1: Customer: Summary type = Group Column 2: Formula (Currency or Numeric): Summary type = Maximum: Formula is SUM({amount}) This will not have a total row. ****** 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.858598769
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850868821
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850451112
Please provide your feedback on this answer.