ANS-0047 · SAVED SEARCHES & FORMULAS
How to Suppress the Grand Total Line in a NetSuite Summary Saved Search
A specific configuration of the Summary Type and Formula fields can effectively remove the grand total row from NetSuite summary saved search results.
Short answer
To prevent a summary saved search from displaying a grand total line, configure the column's Summary Type to 'Maximum' while using a `SUM({amount})` formula. This combination allows the aggregation of data without generating an overall total row at the bottom of the search results.
Scenario
NetSuite users often encounter situations where a summary saved search automatically includes a grand total line at the bottom of the results. While useful in many contexts, this total line may not always be desired, particularly when specific reporting or display requirements necessitate its exclusion. Standard saved search configurations do not offer a direct option to suppress this grand total.
Solution
To prevent a summary saved search from outputting a grand total line, configure the relevant column as follows: Set the Summary Type to 'Maximum'. In the Formula field, enter SUM({amount}). This approach leverages the 'Maximum' summary type to process the data while the SUM({amount}) formula ensures the correct aggregation of values, effectively suppressing the display of the overall total line.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support