Caché MultiValue Basic Reference
SUM
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Adds the values of the elements of a dynamic array.
Synopsis
SUM(dynarray)
Arguments
dynarray An expression that resolves to a dynamic array of numeric values.
Description
The SUM function adds the values the elements in a dynamic array and returns the sum as a dynamic array. If an element is missing or has a null string or a non-numeric value, SUM parses its value as 0 (zero).
The SUM function adds dynamic array values that are on the same dynamic array level. To add all values in a dynamic array, regardless of level, use the SUMMATION function. To add the elements of two dynamic arrays, use the ADDS function.
See Also