The SUM function sums the numbers contained in a column.
Syntax
SUM(
column
)
Parameters
- column: Name of the column that contains the numbers to be added.
Returned value
The SUM function returns a real number.
Additional Information
The SUM function sums the values of the entire column even when used in a calculated column.
Examples
If we have the following data table and define the "Suma" measure:
By taking the measure to a card-type display, we would obtain the sum of the "Valores" column:
Related functions
Scenarios
- Calculation of accumulated totals
- Evaluating a value from a list
- Obtaining the 10 customers who accumulate the most purchases
- Aggregation of two tables with the same structure
- Calculation of sales prior to a given date
- Emulation of the TOTALYTD function
- Range of locations according to the number of units sold
- Show all values even if they are zeros
- Creation of a graph controlling its content with a segmentation
- Calculation of an expression only if the values involved are not null
Category
Mathematical and trigonometric