SUM

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 number or node reference to add.
• value2, ... (Optional): Additional numbers or node references to add.

Return value

Returns the total of the specified values.

Example

SUM(Q1.Actuals Contoso, Q2.Actuals Contoso, Q3.Actuals Contoso, Q4.Actuals Contoso)

In this example, the Total Actuals measure is created using the SUM function, which returns the sum of the quarterly Actuals values for Contoso.

Excel equivalent

SUM