ABS

PQL47 (PQL Function Library - CPM 4.7)

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

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 FLOAT columns.

ABS ( table.column )

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

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

Query

Column1

ABS ( "Table1"."Column1" )

Input

Output

Table1

Result

Was this helpful?

PQL47 (PQL Function Library - CPM 4.7)