Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.Aggregation

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