This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I've got a summary saved search with one SUMMED column value and one GROUPED column value.  Is there a way to add those two columns together?

I know it is possible using a Suitelet but i don't think it would possible using a saved search.

Sure. You could do this by bringing your sum and grouping into a single formula

just- in order to get your grouping in a single formula, you'll have to do max

but as long as you leave your grouping column in your saved search that should be pretty safe

<@UER9Q3SGM> how would that work though, can you please explain ? because lets say we have one column with 10 values(75,85,100,etc) totaling 7500 &amp; one column where there is a fixed amount of 500. How would i get a column totaling 8000 ?

your formula would be `max({fielda}) + sum({fieldb})` and your summary type would be max or min (functionally speaking both are the same)

Add it as a 3rd column in addition to your current columns

However - I would not suggest removing the other 2 columns, because removing the grouping would impact the reliability of the max function