Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    PV function for IBM Planning Analytics (TM1)

      PV returns the initial or principal value of an annuity. 

      In this video, PV will be used to calculate the payment value of an annuity and apply it in the rule to populate the Product Scorecard cube. 

      Where can the PV function be used?

      Rules and TurboIntegrator

        Which TM1 Server version is the PV function available for?

        Version 11 and 12

          What is the syntax for PV?

          PV(payment, interest, periods)​

          • Payment = The amount of the payment made.​
          • Interest = The interest rate.​
          • Periods = The number of periods in the annuity.

          Relevant Functions

          • FV = Returns the future value of an annuity at the time of the last payment
          • PAYMT = Returns the payment amount of an annuity based on the principal amount, rate, and number of periods
          • PV = Returns the initial or principal value of an annuity