SQRT
Description:
This function returns the square root of the mentioned scalar value.
Syntax:
SQRT(Scalar_Expression)
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Value | It is a valid MDX expression that returns a scalar value. |
Example:
WITH
MEMBER [Measures].[Square Root] AS SQRT([Measures].[Internet Sales Amount])
SELECT {[Measures].[Squared], [Measures].[Square Root], [Measures].[Rounded], [Measures].[Absolute]}
ON COLUMNS
FROM [AdventureWorksMF_ValueBased]