Scenario:
The user wants to hide or remove the “Total” row that appears at the bottom of a saved search, particularly when using summary-type results (e.g., Sum, Average). This is often requested to avoid confusion or for formatting/export purposes.
Solution:
As of now, NetSuite does not offer a native feature to hide the Total row in Saved Search results. This limitation applies especially when using summary types like AVG, SUM, COUNT, etc.
This is currently an enhancement logged under: Enhancement #161332 — Ability to hide the Total row in Saved Search results.
You can vote or track this request via the SuiteIdeas portal.
Workaround
While you can’t disable the Total row directly, you can convert numerical summary values into text, which prevents NetSuite from calculating and displaying a total at the bottom.
This is particularly useful when calculating averages where the total row may be misleading.
You can include this formula in your search:
Here is the formula : TO_CHAR(ROUND(AVG({amount}/{quantity}),2))
-----
If you find this information useful, let us know by reacting or commenting on this post!