Skip to content

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

SEERRO

On this page (10)

Returns the fallback when the calculation errors (or comes out blank).

FieldValue
CategoryLogic
TypeScalar (operates value by value)
Arity2 arguments (fixed)
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: SEERRO. Accepted aliases (case-insensitive): iferror.

Syntax#

code
SEERRO(expr; arg2)

All arguments are expressions.

Returns#

The calculation's value, or the fallback on error/blank.

Null handling#

It also falls back when the calculation comes out blank, not only on error.

Evaluation context#

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

Differences from DAX#

  • DAX equivalent: IFERROR
  • Compatibility: DIFFERS from DAX — different semantics, watch out
  • Note: Falls back when the calculation ERRORS OR comes out BLANK — DAX IFERROR only handles errors, not BLANK.

Examples#

code
SEERRO(lucro / receita; 0)

Example with values#

Input: 1 / 0 (error) with fallback -1.

code
SEERRO(1 / 0; -1)  →  -1

Expected result: -1

Business example#

Keep a division by zero from breaking the card — it falls back to an alternative.

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