Sum

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

  1. 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).

  2. Sum Two Calculations:

    SUM(#[Calculation], #[Calculation2])
    

    Returns the sum of the values from two calculation fields.

  3. 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.
Was this article helpful?
0 out of 0 found this helpful