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