The SUM function returns the sum of all numbers in the arguments, which can be numbers or node references.
SUM(value1, ...valueN?) - > number
value1
Number/Node reference
The first node or number to be added. This is a required argument.
...valueN?
The additional nodes or numbers to be added. These are optional arguments.
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])
SUM
(
[East],
[South]
,
[Central]
[West]
)
Last updated 2 years ago
Was this helpful?