SUM

Adds multiple numbers or node references and returns their total to help calculate aggregates and overall values.

The SUM function returns the total of all numbers provided in the arguments by adding them together. The inputs can be numeric values or node references. This function is commonly used to calculate totals, aggregates, and overall values in datasets.

Syntax

SUM(value1,[value2]....)

Arguments

value1 – The first node or number to be added (Required).

value2,...– The additional nodes or numbers to be added (Required).

Example

SUM(COLUMN1, COLUMN2)

In the example below, the SUM Values measure is created using the SUM function, which returns the result of adding MEASURE 1 and MEASURE 2.

Applying SUM function

Excel equivalent

SUM