PRODUCT

The PRODUCT function returns the product of all values in the arguments.

Syntax

PRODUCT(value1, ...valueN?) - > number

Arguments

Arguments	Datatype	Description
value1	Number/Node reference	The first node or number to be multiplied. This is a required argument.
...valueN?	Number/Node reference	The additional nodes or numbers to be multiplied. These are optional arguments.

Example

Consider the below example where we have data for Units sold and price. The objective is to calculate Sales value by multiplying Units sold with Unit price.

Periods	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
Units sold	2000	2351	978	1520	2415	3154	1548	3144	2458	3654	1452	2548
Unit price	6	11	6	7	8	11	7	10	6	5	9	12

To achieve this, the following formula should be written in the [Sales] node.

PRODUCT([Units sold],[Unit price])

Result

Sales	12000	25861	5868	10640	19320	34694	10836	31440	14748	18270	13068	30576