Skip to main content

Celonis Product Documentation

SQUARE
Description

The SQUARE function calculates the square for each input value.

Can be applied to INT or FLOAT columns. The resulting column is of type FLOAT.

Syntax
  SQUARE ( table.column )
 
NULL handling

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

Example

[1]

Calculate the square of three Integers

Query

Column1

         SQUARE ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

1

2

3

null

Result

Column1 : float

1.0

4.0

9.0

null

See also: