Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

MULT

Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

Description

The multiplication operator computes the product of two values.

The multiplication operator can be applied to INT or FLOAT columns or constants. The resulting column is of type INT if both input columns or constants are of type INT. In all other cases, the resulting column is of type FLOAT.

Syntax
MULT ( table.column1 , table.column2 )
table.column1 * table.column2
Examples

[1] Multiply a column of type INT with a constant INT value.

Query

Column1

"Table1"."Column1" * 2

Input

Output

Table1

Column1 : INT

1

2

3

4

Result

Column1 : INT

1

2

3

4

[2] Multiply a column of type FLOAT with a constant FLOAT value.

Query

Column1

"Table1"."Column1" * 2.0

Input

Output

Table1

Column1 : FLOAT

1.0

2.0

3.0

4.0

Result

Column1 : FLOAT

2.0

4.0

6.0

8.0

[3] Multiply a column of type INT with a constant FLOAT value.

Query

Column1

"Table1"."Column1" * 2.0

Input

Output

Table1

Column1 : INT

1

2

3

4

Result

Column1 : FLOAT

2.0

4.0

6.0

8.0

[4] Multiply values of multiple INT and FLOAT columns.

Query

Column1

"Table1"."IntColumn1" * "Table1"."IntColumn2"

Column2

MULT ( "Table1"."IntColumn1", "Table1"."FloatColumn1" )

Column3

"Table1"."FloatColumn1" * "Table1"."FloatColumn2"

Column4

MULT ( "Table1"."IntColumn1", "Table1"."IntColumn2" * "Table1"."FloatColumn1" )

Input

Output

Table1

IntColumn1 : INT

IntColumn2 : INT

FloatColumn1 : FLOAT

FloatColumn2 : FLOAT

Result

Column1 : INT

Column2 : FLOAT

Column3 : FLOAT

Column4 : FLOAT