Returns the fallback when the calculation errors (or comes out blank).
| Field | Value |
|---|---|
| Category | Logic |
| Type | Scalar (operates value by value) |
| Arity | 2 arguments (fixed) |
| Compiles to SQL (calculated column) | Yes |
| Version | Formula engine v3. |
Aliases#
Canonical name: SEERRO. Accepted aliases (case-insensitive): iferror.
Syntax#
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#
SEERRO(lucro / receita; 0)Example with values#
Input: 1 / 0 (error) with fallback -1.
SEERRO(1 / 0; -1) → -1Expected 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.