Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

SQRT

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 SQRT function calculates the square root of the specified value.

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

Syntax
SQRT ( table.column )
Example

[1] Calculate the square root of three integers.

Query

Column1

SQRT ( "Table1"."Column1" )

Input

Output

Table1

Column1 : INT

1

4

9

null

Result

Column1 : FLOAT

1.0

2.0

3.0

null