image\Dql_0023.gifabs (absolute value)

Type

Math Function

Purpose

The abs function converts a numeric value to a positive, unsigned numeric value.

Syntax

abs( NUMERIC VALUE)

Returns

A numeric value.

Usage

The numeric value in a Math function can be a constant value (as shown below), a variable, a field value or an expression.

The abs function can only be used with a numeric value. A non-numeric value always returns a value of 0.

Examples

 abs( -453)

 Returns: 453

 

 abs( 4.53)

 Returns: 4.53