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
Xcannot 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 |