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.

This function uses 32-bit Integers, therefore the range of valid parameters is

-2147483648 and [phone]

Syntax

Abs(number)

Abs(-123.4567) => 123.4567

Abs(unknownnumber) => Invalid expression

Parameters

Name	Type	Required	Description
number	numeric	☑️	a number

Examples

Function call	Result
Abs(123.456)	123.456
Abs(-123.456)	123.456
Abs(1.23456*10^6)	1234560