Skip to main content
Returns the absolute, non-negative value of a number Category: math Syntax:
Abs([number])
Returns: Number Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
numbernumber or column✓ YesThe number or column of numbers that is being evaluated
Allowed Column Types for number: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

Abs([Distance Covered])
Converts all negative values in Distance Covered column to positive values
Abs(-5)
Returns the absolute value of -5 Result: 5
Abs(3.14)
Returns the absolute value of 3.14 Result: 3.14
Last modified on March 13, 2026