Today, we’re borrowing the tip on a summary saved search from P M on Stack Overflow. I ran into this issue today where a Saved Search included a Sum column, but I didn’t want it to include the total at the bottom. The search is being exported as CSV on a regular basis to update another system, and the total row was causing an error. Now, while the error wasn’t causing anything to fail—because everything was functioning correctly—an error email was being sent every time. Unfortunately, if you allow yourself to grow accustomed to error emails then when a real issue comes up you won’t be paying attention when you’re really needed!
A Solution
So, how do I remove that “Total” row from a summary saved search? User The Velour Frogg gives us the perfect answer:
- Change the field you are summing (in our case, the amount field) to a Formula (Numeric) field
- In the formula box, enter
SUM({amount}), or whatever the field ID is that you’re summing - Set the summary type of your result column to
Maximum
Here’s a before and after of our column:
Before:
After:
Conclusion
We hope this tip has been helpful! At SuiteRep, we focus on all things NetSuite so you can focus on better business results. Contact us today to learn how we can partner with you.