Abs function

Edit online

Returns the absolute value of a number or expression, removing any negative sign.

Where to use

This function can be used in:
  • Data sets
  • Calculated metrics and reports with metric columns
  • Formula columns in report tables
  • Dynamic text

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

If the result of the expression is negative, Abs converts it to a positive number. If the result is positive, it remains unchanged.

Example

The following example returns the absolute value of the numbers in a column called Balance.

=Abs(Balance)