Sum

The Sum function adds the numerical values in a column or group.

📘

The Sum function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Syntax

Sum(column)

Function arguments:

• column (required) - The column of numbers to add together. Any Null or empty values are skipped.

Example

Sum([Price]) - Sum([Cost])

• Finds the total Profit by finding the sum of the Prices and subtracting the sum of the Costs.

📘

When performing numeric operations on values, such as using the addition operator + to sum together values, if one value is Null then the result of the entire numeric operation will be Null.