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

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

NULL handling

If one of the input values is NULL, the result is NULL as well.

Examples


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

Query
Column1
"Table1"."Column1" * 2
Input
Table1
Column1 : INT
1
2
3
4
Output
Result
Column1 : INT
2
4
6
8



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

Query
Column1
"Table1"."Column1" * 2.0
Input
Table1
Column1 : FLOAT
1.0
2.0
3.0
4.0
Output
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
Table1
Column1 : INT
1
2
3
4
Output
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
Table1
IntColumn1 : INTIntColumn2 : INTFloatColumn1 : FLOATFloatColumn2 : FLOAT
20
5
10.0
20.0
30
15
14.0
7.0
40
null
12.0
22.0
50
30
null
23.0
null
45
14.0
null
Output
Result
Column1 : INTColumn2 : FLOATColumn3 : FLOATColumn4 : FLOAT
100
200.0
200.0
1000.0
450
420.0
98.0
6300.0
null
480.0
264.0
null
1500
null
null
null
null
null
null
null


  • No labels