Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the sum of all the values in a set.
Syntax
SUM(aggregate)
aggregate |
Specifies the field name or formula to aggregate. |
Remarks
- SUM can be used with fields that contain numeric values only.
- Null values are ignored.
Example
| Formula | Result |
|---|---|
SUM(Sales Orders) |
Returns the sum of all sales orders, a value such as $139,453.23. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Aggregate Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)