workbook.CalculatedMeasure

Note:

The content in this help topic applies to SuiteScript 2.x.

Object Description

A calculated measure.

Use calculated measures to calculate a value based on the value of fields or other measures.

Use workbook.createCalculatedMeasure(options) to create this object.

Supported Script Types

Server scripts

For more information, see SuiteScript 2.x Script Types.

Module

N/workbook Module

Methods and Properties

CalculatedMeasure Object Members

Since

2021.2

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/workbook Module Script Samples.

            // Add additional code
...
var myCalculatedMeasure = workbook.createCalculatedMeasure({
    label: 'Balance',
    expression: workbook.createExpression({
        functionId: workbook.ExpressionType.MINUS,
        parameters: {
            operand1: workbook.createExpression({
                functionId: workbook.ExpressionType.MEASURE_VALUE,
                parameters: {
                    measure: myFirstDataMeasure
                }
            }),
            operand2: workbook.createExpression({
                functionId: workbook.ExpressionType.MEASURE_VALUE,
                parameters: {
                    measure: mySecondDataMeasure
                }
            })
        }
    })
});
...
// Add additional code

Syntax

Related Topics