Multiplies corresponding values from multiple columns and returns their sum
Category: aggregate
Syntax:
SumProduct([column1], [column2])
Number
Context Filtering: ✗ No
Parameters
| Name | Type | Required | Description |
|---|
column1 | column | ✓ Yes | The first numeric column to multiply |
column2 | column | ✓ Yes | The second numeric column to multiply |
column1: INT, FLOAT, DECIMAL
Allowed Column Types for column2: INT, FLOAT, DECIMAL
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Examples
SumProduct([Quantity], [Price])
Last modified on March 13, 2026
