Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
SQL Formula to Sum Results in Search
Is there a way to create a formula in NetSuite saved searches that does the same thing as this SQL Sum Expression:
SELECT department, SUM(sales) as "Total sales"
FROM order_details
GROUP BY department;
This would be very helpful for creating summary results that require me to divide the sum of multiple result columns.
Thank you
0