Description
The SUM function calculates the total sum of a list of numbers.
Usage
This function is used to add one or more numbers together.
Syntax:SUM(number1, [number2], …)
Examples
-
Sum Quarterly Sales:
SUM(#[Sales Q1], #[Sales Q2], #[Sales Q3], #[Sales Q4])Returns the total sales from the first quarter (Q1) through the fourth quarter (Q4).
-
Sum Two Calculations:
SUM(#[Calculation], #[Calculation2])Returns the sum of the values from two calculation fields.
-
Sum Unique Counts of Records:
SUM(COUNTU(#[IT Risk Assessment].[ID]), COUNTU(#[Ent Risk Assessment]))Returns the sum of the unique count of IT Risk Assessment and Ent Risk Assessment records.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| number1 | Number | The first number to add. |
| [number2] | Number | (Optional) Additional numbers to add. |
Returns
Type: Number
- Produces the total sum of the specified numbers.