<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

LN function for IBM Planning Analytics (TM1)

    LN converts a number into an absolute value. returns the natural base e logarithm of a number.

    In the video, LN will be used to calculate natural base e logarithms and apply them in the rule to populate the Product Scorecard cube. 

    Where can the LN function be used?

    Rules and TurboIntegrator

      Which TM1 Server version is the LN function available for?

      Version 11 and 12

        What is the syntax for LN?

        LN(x)​

        • x = A positive number

        Relevant Functions

        • ABS = Converts a number into an absolute value.
        • ASIN = Returns the angle, in radians, whose sine is x.
        • ATAN = Returns the angle, in radians, whose tangent is x.
        • COS = Returns the cosine of an angle expressed in radians.
        • EXP = Returns the natural anti-log of a number.
        • INT = Returns the largest value that is less than or equal to a specified value.
        • ISUND = Returns 1 if the argument value is undefined.
        • LN = Converts a number into an absolute value. Returns the natural base e logarithm of a number.
        • LOG = Returns the base 10 logarithm of a positive number.
        • MAX = Returns the largest number between two numbers.
        • MIN = Returns the smallest number between two numbers.
        • MOD = Returns the remainder after a number is divided by a divisor.
        • RAND = Function generates a random number.
        • ROUND = Function rounds a number to the nearest integer.
        • ROUNDP = Rounds a number at a specified decimal precision.
        • SIGN = Determines if the number is positive or negative.ACOS = Returns the angle, in radians, whose cosine is x.
        • SIN = Returns the sine of an angle expressed in radians.
        • SQRT = Returns the square root of a given value.
        • TAN = Returns the tangent of an angle expressed in radians.