Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.Measure

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.Measure for more information.

N/workbook Module
workbook.Measure
Object Description: A measure. A measure can be used when you create an aspect, a section, a conditional filter, or a measure sort. You can create a measure using workbook.createMeasure(options).
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Module: N/workbook Module
Methods and Properties: Measure Object Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.Measure

Example:

// Code Example 1
// Add additional code
//...
// Create a basic single expression Measure
var myMeasure = workbook.createMeasure({
expression: myExpression
});

// Create a basic multi-expression Measure
var myMeasure = workbook.createMeasure({
expressions: [myExpression]
});

// Create a comprehensive single expression Measure
var myMeasure = workbook.createMeasure({
label: 'My Measure',
aggregation: workbook.Aggregation.MAX,
expression: myExpression
});

// Create a comprehensive multi-expression Measure
var myMeasure = workbook.createMeasure({
label: 'My Measure',
aggregation: workbook.Aggregation.COUNT,
expressions: [myExpression]
});

// View a workbook.Measure used in a ChartDefinition
var myWorkbook = workbook.load ({
id: myWorkbookId
});

// Note that some Measure properties may be empty/null based on the loaded workbook
var myMeasure = myWorkbook.chartDefinitions[0].aggregationFilters[0].sortBys[0].measure;
log.audit({
title: 'Measure aggregation = ',
details: myMeasure.aggregation
});
log.audit({
title: 'Measure label = ',
details: myMeasure.label
});
log.audit({
title: 'Measure expression = ',
details: myMeasure.expression
});
log.audit({
title: 'Measure expressions = ',
details: myMeasure.expressions
});
//...
// Add additional code

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159008333958.html