In NetSuite, in a search when using grouped results, is it possible to compute average based on grouped row count only

AI generated answer (using internal Slack threads):

In NetSuite, when using grouped results in a search, it is indeed possible to compute the average based on the grouped row count only. This can be achieved by using the 'sum' summary type in your search columns and artificially grouping all your results together. For example, if you have a formula column with just

1

as the formula, you can group on that. This will allow you to get the aggregate totals without having to iterate through the rows. However, please note that the totals will always show at the bottom of grouped searches in columns where the summary type is 'sum'. If you want to count etc, you need to use a summary type with a formula and case when = 1 to sum them up. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******