LN (x)

Description:

This function returns the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).

Syntax: LN (Number)

Number

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

Remarks

• The number argument is compulsory.
• LN is the inverse of the EXP function.
• This is the number that is the positive real number for which you want the natural logarithm.

Example

The LN function can be used in any database where you have stored a value for which you want to determine the natural logarithm value, or the inverse of a value determined through an EXP function, for both cases it is possible to do that with the help of this function. This function displays the value which the natural logarithm value of the number specified in a formula or the range in the cube and this is the number that is the parameter given to the function.

=LN (86)	-Natural logarithm of 86 (4.454347)
=LN (2.7182818)	-Natural logarithm of the value of the constant e (1)
=LN (EXP (3))	-Natural logarithm of e raised to the power of 3 (3).
=LN ("range")	-Natural logarithm value of the number in that range.

 

Let us take the example of a cube in PowerOLAP which has data which is the information in numbers for which you want to calculate the LN value. If in the same dimension in another member or in another dimension in another cube, you want to display the natural logarithm values for the number parameter, then it is appropriate to use the LN function to calculate this result. 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 same dimension, or you can even do this for a different dimension in a different cube.



The formula above writes values into the "TrigValData" cube to the "LN" member by calculating the natural logarithm value for the number in the "Number" member of the "TrigValues" dimension. The LN function takes the "Number" member which is a number given to the function as a parameter and it converts this value to the natural logarithm for the number, and the calculated result is written into the "TrigValData" cube in the "LN" member of the "TrigValues" dimension.