Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

SQUARE

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

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