SUM
The SUM function returns the sum of all numbers in the arguments, which can be numbers or node references.
Syntax
SUM(value1, ...valueN?) - > number
Arguments
Arguments | Datatype | Description |
---|---|---|
value1 | Number/Node reference | The first node or number to be added. This is a required argument. |
...valueN? | Number/Node reference | The additional nodes or numbers to be added. These are optional arguments. |
Example
Consider sales of a particular product across different regions East, South, Central and West to be as follows. The total sales is to be calculated.
To achieve this, the following formula should be written in the [Total Sales] node:
SUM
(
[East],
[South]
,
[Central]
,
[West]
)
Result
Last updated