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 |
Last updated