Skip to content

Abs

Returns the absolute, non-negative value of a number

Category: math

Syntax:

Abs([number])

Returns: Number

Context Filtering: ✓ Yes

Parameters

Name Type Required Description
number number or column ✓ Yes The 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