Abs function
Returns the absolute value of a number or expression, removing any negative sign.
Syntax
Abs(expression)
Parameters
expression: A numeric value or a formula that evaluates to a number. Can include variables, constants, or other functions. Optional
Return type
Number
If the result of the expression is negative, Abs converts it to a positive number. If the result is positive, it remains unchanged.
Examples
Abs(-5)Returns 5
Abs(Sum(Budget) - Sum(Cost))
Returns the absolute difference between total budget and cost
Abs(Price * Quantity)
Returns the absolute value of the product of price and quantity
Note: You can pass a simple number, a column reference, or a full
formula as the argument.