Skip to main content

Celonis Product Documentation

PRODUCT
Description

PRODUCT calculates the product over an INT or FLOAT column.

The data type of the result is the same as the input column data type. So the product of an INT column will be of type INT.

Syntax
 PRODUCT ( table.column )
NULL handling

NULL values are ignored, so they do not influence the result. If all the values of a group are NULL or an overflow occurs during calculation, the result for this group is also NULL.

Example

[1]

Product of small integers.

Query

Column1

         PRODUCT ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

Column2 : int

1

2

3

4

Result

Column1 : int

3

[2]

Product of big integers with overflow.

Query

Column1

         PRODUCT ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

Column2 : int

2

2

9223372036854775807

4

Result

Column1

null