Description:
This function returns the cosine of the given angle.
Syntax: COS (Number)
Remarks
Example
The COS function can be used in any database where you have stored the angle 0 values data and you want to convert that into a cosine value, it is possible to do that with the help of this function. This function displays the cosine value of the angle that is the number in radians which is the parameter given to the function.
=COS (1.047) |
-Cosine of 1.047 radians (0.50) |
=COS (1.047) |
-Cosine of -1.047 radians (0.50) |
=COS ("range") |
-Cosine of the number in that range in radians. |
Let us take the example of a cube in PowerOLAP which has data which is the information about the values of an angle. If in the same dimension in another member you want to display the cosines of the angle given in radians, then it is appropriate to use the COS function to convert the angle values into cosine values. 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.
The formula above writes values into the "TrigValData" cube to the "Cosine" member by calculating the cosine for the number in the "Angle" member of the "TrigValues" dimension. The COS function takes the angle value in radians which is a number given to the function as a parameter and it converts it into cosine value and the calculated result is written into the "TrigValData" cube in the "Cosine" member of the "TrigValues" dimension.