Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

ABS

On this page (10)

Absolute value (no sign).

FieldValue
CategoryMath
TypeScalar (operates value by value)
Arity1 argument (fixed)
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: ABS. Accepted aliases (case-insensitive): (nenhum).

Syntax#

code
ABS(expr)

All arguments are expressions.

Returns#

Number.

Null handling#

Text that is not a number, or a blank value in a calculation, becomes a friendly error (pt-BR) — never a silent zero.

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: ABS
  • Compatibility: Compatible with DAX
  • Note: Same absolute value.

Examples#

code
ABS(lucro)

Example with values#

Input: profit = -150.

code
ABS(-150)  →  150

Expected result: 150

Business example#

Show the size of a deviation from target without the sign (above or below gives the same magnitude).

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links