Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

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 )
NULL handling

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

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

See also: