Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.createMeasure(options)

{workbook}.createMeasure({aggregation: {string},expression: {workbook.Expression}},expressions: {workbook.Expression[]},label: {string}})

N/workbook Module
workbook.createMeasure()
Method Description: Creates a measure, which includes an aggregation, a label, and one or more expressions.
Returns: workbook.Measure
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: None
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.createMeasure(options)

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.MEDIAN,
expression: myExpression
});

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

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