SQRT

Calculates the square root of a number to support mathematical and analytical computations.

The SQRT function returns the square root of a given number. It calculates the value that, when multiplied by itself, equals the input number. This function is commonly used in mathematical calculations, statistical analysis, and scientific computations involving area, distance, or variance.

Syntax

SQRT(value)

Arguments

value – The number or node for which you want the square root (Required).

Example

SQRT(COLUMN1)

In the example below, the Square_Root Values measure is created using the SQRT function, which returns the square root value of values in MEASURE 3.

Applying SQRT Function

Excel equivalent

SQRT