SQRT (x)

Description:

This function returns a positive square root.

 

Syntax: SQRT (Number)

• Number : Enter a number or a range in a PowerOLAP cube for which you want the square root value.

Remarks

• The number argument is compulsory.
• This is the number for which you want the square root.
• If number is negative, SQRT returns the #NUM! error.

Example

The SQRT function can be used in any database where you have stored a value for which you want to calculate the square root value and it is possible to do that with the help of this function. This function displays the Square root value of any number specified in a formula or as a range in a cube and this is the number that is the parameter given to the function.

=SQRT (16)	-Square root of 16 (4)
=SQRT (-16)	-Square root of -16, an error is returned (#NUM!) because the number is negative.
=SQRT (ABS (-16))	-Square root of the absolute value of -16. (4).
=SQRT ("range")	-Square root of the number in that range.

 

Let us take the example of a cube in PowerOLAP which has data which is the information in numbers for which you want to calculate the square root. If in the same dimension in another member or in another dimension in another cube, you want to display these square root values for the number parameter, then it is appropriate to use the SQRT function to calculate the square root for the number. In this case we can write a formula in the cube in PowerOLAP to pull in values from one member of a dimension of a cube and write them to the formula and derive the values for the other member of the dimension, or you can even do this for a different dimension in a different cube.



The formula above writes values into the "TrigValData" cube to the "SQRT" member by calculating the square root value for the number in the "Number" member of the "TrigValues" dimension. The SQRT function takes the "Number" member which is a number given to the function as a parameter and it converts this value to its square root and the calculated result is written into the "TrigValData" cube in the "SQRT" member of the "TrigValues" dimension.