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

Hello, is it possible to reference the sum of a column in a dataset in a SuiteScript? Or how do get that data via SuiteScript?

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510789115.html|Column.aggregate> in combination with <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510789147.html|Column.groupBy>

<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_157960623712.html|SuiteQL> is usually more popular if you know how to build the sql yourself