Easy to Create, Easy to Change - Easy to use!

Function::Mathematical

Abs (absolute value)

abs(NUMERIC VALUE) abs(-1232) abs(0.323) abs(MySumField*YourSumfield)

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

Parameters


Numeric Value i.e. any number between -n via 0 to +n

Returns/Result


Positive Numeric Value 0 to +n

Examples


Example 1


abs(-8)

Result: 8

Example 2


abs(8)

Result: 8

Example 3


Alternative DataEase derivation that will give same result:

if (Field<0,Field*-1,Field)

Reference

abs (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

See Also


On the forum about Abs (absolute value)

On the blog about Abs (absolute value)