ABSOLUTE()

ABS() returns the absolute value of a numeric expression.

Use ABS() to determine the absolute value of a population before generating a random sample.

Function Format

ABS(N)

The ABS() function returns the absolute value of the specified numeric expression N.

Examples

ABS(-7.2)= 7.2

ABS(88.2)= 88.2

ABS(5)= 5

To create a field that is the difference between two fields (AMT1 and AMT2), specify:

ABS(AMT1 - AMT2)