Abs

The Abs() function takes the absolute value of a number.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns an absolute number

Returns Invalid expression if the parameter is not a valid number.

Syntax

Abs(number)

Abs(-123.4567) => 123.4567

Abs(unknownnumber) => Invalid expression

Parameters

NameTypeRequiredDescription

number

numeric

☑️

a number

Examples

Function callResult

Abs(123.456)

123.456

Abs(-123.456)

123.456

Abs(1.23456*10^6)

1234560

Last updated