This function returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.
Syntax: ATAN (Number)
- Number : Enter a number or a range in another PowerOLAP cube for which you want the arctangent value.
Remarks
- The number argument is compulsory.
- Number is the tangent of the angle you want.
Example
The ATAN function can be used in any database where you have stored the tangent values data and you want to convert that into an arc-tangent value, it is possible to do that with the help of this function.
This function displays the arc-tangent value of the tangent angle that is the number parameter given to the function.
=ATAN (1) |
-Arctangent of 1 in radians, pi/4 (0.79) |
=ATAN (-1) |
-Arctangent of 1 in radians, (-0.79) |
=ATAN ("range") |
-Arctangent 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 tangent values of an angle. If in the same dimension in another member you want to display the arctangent values in radians of the tangent angle, then it is appropriate to use the ATAN function to convert the tangent values into arc-tangent. 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 "ArcTangent" member by calculating the arctangent for the number in the "Tangent" member of the "TrigValues" dimension. The ATAN function converts the tangent of an angle which is a number given to the function as a parameter and it converts this into the arctangent and the calculated result is written into the "TrigValData" cube in the "ArcTangent" member of the "TrigValues" dimension.