1. SuiteCloud Platform
  2. SuiteScript
  3. SuiteScript 2.x API Reference
  4. SuiteScript 2.x Modules
  5. N/workbook Module
  6. workbook.Aggregation

workbook.Aggregation

Note:

JavaScript does not include an enumeration type. The SuiteScript 2.x documentation uses the term enumeration (or enum) to describe a plain JavaScript object with a flat, map-like structure. In this object, each key points to a read-only string value.

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

Values

Value

AVG

COUNT

COUNT_DISTINCT

MAX

MEDIAN

MIN

SUM

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. Also see Full scripts in the Tutorial: Creating a Workbook Using the Workbook API topic.

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

Related Topics

General Notices