rate Function [AX 2012]

Updated: December 11, 2009

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Calculates the interest that is required for the current investment value to attain the future value over the specified number of periods.


real rate(
    real _future_value,
    real _current_value,
    real _terms)

Parameter

Description

_future_value

The future value of the investment.

_current_value

The current value of the investment.

_terms

The number of periods over which the investment spans.

The calculated interest rate.

  • rate(10000,1000,20); //Returns the value 0.12.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: