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

ArgumentsDatatypeDescription

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