|
Returns
the sum of the non-null elements of a given set of numbers.
Parameters
Parameter
|
Description
|
|---|
n1
|
A numeric value or expression.
|
n2 (optional)
|
Additional numeric values and/or expressions.
|
Note: FormCalc follows the IEEE-754
international standard when handling floating point numeric values.
For more information, see Number literals.
ExamplesThe
following expressions are examples of using the Sum function:
Expression
|
Returns
|
|---|
Sum(2, 4, 6, 8)
|
20
|
Sum(-2, 4, -6, 8)
|
4
|
Sum(4, 16, "abc", 19)
|
39
|
Sum(Amount[2], Amount[5])
|
Totals the third and sixth occurrences of Amount.
|
Sum(Round(20/3, 2), Max(Amount[*]), Min(Amount[*]))
|
Totals the value of 20/3 rounded to two
decimal places, as well as the largest and smallest non-null occurrences
of Amount.
See also Max, Min,
and Round.
|
|
|
|
