SUM
The following section describes the syntax and usage of the SUM function in ActivityInfo.
Description
The SUM function is used to find the summation of a set of values. The function adds all values in the set together to produce a total sum.
Syntax
SUM(val1, val2, ...)
| Argument | Required | Description |
|---|---|---|
| val1 | Yes | A numeric value. |
| val2 | Yes | Another numeric value. |
| ... | No | Any further numeric values. If an argument is missing, NA, or non-numeric, it will be excluded from the calculation. |
Result
The numeric sum total of the set of input arguments.
Example
We will be using the SUM function to calculate the total row value of a set of three columns.
Arguments
We will be using three Quantity fields:
- "Value 1" (with code "val1")
- "Value 2" (with code "val2")
- "Value 3" (with code "val3")
Formula
SUM(val1,val2,val3)
Results
