Skip to content

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

EHVAZIO

On this page (10)

1 when the value is blank.

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

Aliases#

Canonical name: EHVAZIO. Accepted aliases (case-insensitive): isblank.

Syntax#

code
EHVAZIO(expr)

All arguments are expressions.

Returns#

Logical (1 = blank, 0 = not blank).

Null handling#

This is exactly the blank test (returns 1 when blank).

Evaluation context#

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

Differences from DAX#

  • DAX equivalent: ISBLANK
  • Compatibility: Compatible with DAX
  • Note: Returns 1/0 (a number), not TRUE/FALSE.

Examples#

code
EHVAZIO(desconto)

Example with values#

Input: 1 / 0 returns blank.

code
EHVAZIO(1 / 0)  →  1

Expected result: 1

Business example#

Apply a business rule — customer tier, order status, target hit or missed.

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