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