Returns the sum of all values in a set of numbers.
Sample usage
SUM(Quantity Sold)
Syntax
SUM(X)
Parameters
X
- a numeric field or expression.
Notes
X
cannot be an aggregated field or the result of an aggregation function.
Example
Consider the following example. The data source contains a field called "Quantity Sold" with the number of items sold per purchase. Use the SUM
function to compute the sum of these values.
Example formula | Input | Output |
---|---|---|
SUM(Quantity Sold) |
|
287 |