Function: Abs
Description
Returns the absolute value of a number.
Syntax
Abs(number)
Arguments
Number can be a constant, a numeric field, or an expression that results in a number. It can also be a function that returns a number.
Return value
This function returns a positive number.
Calculated field example
If the Balance field contained the value of -159.95, the following calculated field expression would return the number 159.95: Abs(Balance)
Filter/Find example
Records with a Balance field value of -159.95 or 227.00 can be selected or found using the expression: Abs(Balance)>100.00
© 2024 Altair Engineering Inc. All Rights Reserved.