PV(rate, terms, payment[,future value, type] )
Argument
| Required/
Optional
| Description
|
---|---|---|
rate
| Required
| Numeric. Interest rate earned in each period. Expresses as a decimal number. Divide the rate by 100 to express it as a decimal number.
|
terms
| Required
| Numeric. Number of period or payments. Must be greater than 0.
The Spark engine writes null values for rows when the terms argument passes a 0 value. In the native environment, the Data Integration Service rejects the row and does not write it to the target.
|
payments
| Required
| Numeric. Payment amount due per period. Must be a negative number.
|
future value
| Optional
| Numeric. Cash balance after the last payment. If you omit this value, PV uses 0.
|
types
| Optional
| Boolean. Timing of the payment. Enter 1 if payment is at the beginning of period. Enter 0 if the payment is at the end of period. Default is 0. If you enter a value other than 0 or 1, the
PowerCenter Integration Service treats the value as 1.
|
PV( 0.0075, 12, -500, 20000, TRUE )