Skip to content

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

RAIZ

On this page (10)

Square root.

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

Aliases#

Canonical name: RAIZ. Accepted aliases (case-insensitive): sqrt.

Syntax#

code
RAIZ(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: SQRT
  • Compatibility: Compatible with DAX
  • Note: Square root; a negative number becomes an error (DAX SQRT would also return an error).

Examples#

code
RAIZ(area)

Example with values#

Input: area = 144.

code
RAIZ(144)  →  12

Expected result: 12

Business example#

Normalize financial numbers — round prices, remove the sign from a deviation, compute powers/roots.

Common errors#

RAIZ: número negativo.


← Back to the formula index

Related links