Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

ABS

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

Description

ABS is a mathematical function that returns the absolute (positive) value of the specified numeric expression.

ABS changes negative values to positive values. ABS has no effect on zero or positive values.

It can be applied to INT or FLOATcolumns.

Syntax
ABS ( table.column )
NULL handling

If an input value is NULL, the result is NULL as well.

Example

[1] ABS with one negative value and one null value.

Query

Column1

ABS ( "Table1"."Column1" )

Input

Output

Table1

Column1 : INT

1

-1

0

null

Result

Column1 : INT

1

1

0

null