Modules
Objects/Functions
SuiteScript 2.0
workbook.Aggregation.{|COUNT,COUNT_DISTINCT,MAX,MEDIAN,MIN,SUM|}
N/workbook Module
workbook.Aggregation
Enum Description:
Holds string values for aggregation types. This enum is used pass the aggregation parameter to workbook.createMeasure(options).
Module:
N/workbook Module
Sibling Module Members:
N/workbook Module Members
Since:
2020.2
Search NetSuite -
https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.Aggregation
Example:
// Code Example 1
// Add additional code
//...
var myCountMeasure = workbook.createMeasure({
label: 'Count Measure',
aggregation: workbook.Aggregation.COUNT,
expression: myCountExpression
});
var myCountDistinctMeasure = workbook.createMeasure({
label: 'Count Distinct Measure',
aggregation: workbook.Aggregation.COUNT_DISTINCT,
expression: myCountDistinctExpression
});
var myMaxMeasure = workbook.createMeasure({
label: 'Max Measure',
aggregation: workbook.Aggregation.MAX,
expression: myMaxExpression
});
var myMedianMeasure = workbook.createMeasure({
label: 'Median Measure',
aggregation: workbook.Aggregation.MEDIAN,
expression: myMedianExpression
});
var myMinMeasure = workbook.createMeasure({
label: 'Min Measure',
aggregation: workbook.Aggregation.MIN,
expression: myMinExpression
});
var mySumMeasure = workbook.createMeasure({
label: 'Sum Measure',
aggregation: workbook.Aggregation.SUM,
expression: mySumExpression
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159058742898.html