SumProduct

The SumProduct function returns the sum of the product of values in a series of columns.

📘

The SumProduct 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

SumProduct(column, ...)

Function arguments:

• column (required) - A column to be multiplied and summed. You can enter in any number of columns to be multiplied together.

Example

SumProduct([Quantity], [Unit Price])

• Finds the sum of the product of the columns [Quantity] * [Unit Price]
• This function is an alias for Sum([Quantity] * [Unit Price])