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 division operator computes the quotient of two values.
The division operator can be applied to INT or FLOAT columns or constants. The data type of the result is always a FLOAT (Since: CELONIS 4.5). If the values of the second input column or constant (the divisor) is 0 (division by zero), the resulting value is set to null.
Syntax
DIV ( 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
Query
Column1
"Table1"."Column1" / "Table1"."Column2"
Query
Column1
"Table1"."IntColumn1" / "Table1"."IntColumn2"
Column2
DIV ( "Table1"."IntColumn1" , "Table1"."FloatColumn1" )
Column3
"Table1"."FloatColumn1" / "Table1"."FloatColumn2"
Column4
"Table1"."IntColumn1" / "Table1"."IntColumn2" / "Table1"."FloatColumn1"
Column5
DIV ( "Table1"."IntColumn1" , "Table1"."IntColumn2" / "Table1"."FloatColumn1" )