This function Returns the sine of the given angle
Syntax: SIN (number )
- Number : Enter a number or a range in another PowerOLAP cube for which you want the sine value.
Remarks
- The number argument is compulsory.
- Number : is the angle in radians for which you want the sine.
Example
The SIN function can be used in any database where you have stored the angle values data and you want to convert that into the sine value, it is possible to do that with the help of this function. This function displays the sine value of an angle specified in radians that forms the number parameter given to the function.
=SIN (0.99) |
-Sine of 0.99 in radians (0.84) |
=SIN (-0.99) |
-Sine of -0.99 in radians (-0.84) |
=SIN ("range") |
-Sine 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 values of an angle given in radians. If in the same dimension in another member you want to display the sine values for the angle, then it is appropriate to use the SIN function to convert the angle values into 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 "Sine" member by calculating the "sine" value for the number in the "Angle" member of the "TrigValues" dimension. The SIN function takes the angle in radians which is a number given to the function as a parameter and it converts this value to its sine and the calculated result is written into the "TrigValData" cube in the "Sine" member of the "TrigValues" dimension.