In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
numPeriods = 5
Pmt = 10
PV = 3500
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the Rate function, and returned the Interest rate value.
Name
Rate
Syntax
Rate (Real numPeriods, Real Pmt, Real PV)
Purpose
To return the interest rate per period for an annuity.
Description
Returns the interest rate per period for an annuity.
Return Type
Double
Parameters
numPeriods [System.Double]
Pmt [System.Double]
PV [System.Double]