Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

SQUARE

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