Definition
The ABS() function returns the absolute (positive) value of the specified numeric expression. (ABS changes negative values to positive values. ABS has no effect on zero or positive values.)
Syntax
ABS(numeric_expression)
where numeric_expression is required and is an expression of the exact numeric or approximate numeric data type category. It can also be a field e.g. [Comp Worksheet Line Item: (Host) Payperiod Pay Amount]
Example(s)
What to use in Custom SQL field:
ABS(-1234.567)
Field Output:
