TAN (x)

Description:

This function returns the tangent of the given angle.

Syntax: TAN (number)

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

Remarks

• The number argument is compulsory.
• Number : is the angle in radians for which you want the tangent.

Example

The TAN function can be used in any database where you have stored the angle values data and you want to convert that into a tangent value, it is possible to do that with the help of this function. This function displays the tangent value of an angle in radians that is the number parameter given to the function.

=TAN (0.785)	-Tangent of 0.785 radians (1)
=TAN (-0.785)	-Tangent of -0.785 in radians (-1)
=TAN ("range")	-Tangent 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 Tangent values of the given angle, then it is appropriate to use the TAN function to convert the angle values into the 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.



The formula above writes values into the "TrigValData" cube to the "Tangent" member by calculating the tangent for the number in the "Angle" member of the "TrigValues" dimension. The TAN function converts an angle value which is a number given to the function as a parameter and then converts this into the tangent value and the calculated result is written into the "TrigValData" cube in the "Tangent" member of the "TrigValues" dimension.