MicroStrategy ONE

Square root

Returns the square root of a given positive number. This is a single-value function.

Syntax

Sqrt(Argument)

Where:

Argument is a metric representing a list of positive real numbers.

Usage Notes

A NULL is returned if an argument value is less than 0.

Example

This simple example illustrates the results of using the Sqrt function.

Sqrt(25) = 5

Sqrt(169) = 13