This function returns the arcsine, or inverse sine of a number. The arcsine is the angle whose sine is number. The returned angle is given in radians in the range - pi/2 to pi/2.
Syntax: ASIN (Number)
- Number : Enter a number or a range in another PowerOLAP cube for which you want the arcsine or the inverse sine value.
Remarks
- The number argument is compulsory.
- Number is the sine of the angle you want and must be from -1 to 1.
Example
The ASIN function can be used in any database where you have stored the sine angles data and you want to convert that into an arc-sine value, it is possible to do that with the help of this function.
This function displays the arc-sine value of the sine angle that is the number parameter given to the function.
=ASIN (-0.5) |
-Arcsine of -0.5 |
=ASIN (0.18) |
-Arcsine of 0.18 |
=ASIN ("range") |
-Arcsine of the number in that range. |
Let us take the example of a cube in PowerOLAP which has data which is the information about the sine values of an angle. If in the same dimension in another member you want to display the arcsines in radians of the sine angle, then it is appropriate to use the ASIN function to convert the sine values into arc-sine. 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.
.png)
The formula above writes values into the "TrigValData" cube to the "ArcSine" member by calculating the arcsine for the number in the "Sine" member of the "TrigValues" dimension. The ASIN function converts the sine of an angle which is a number given to the function as a parameter and it converts this to the arcsine and the calculated result is written into the "TrigValData" cube in the "ArcSine" member of the "TrigValues" dimension.