NPV function

This topic describes the formula syntax and usage of the NPV function in the Data Quality Execute Formula transform.

Description

Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

Syntax

NPV(rate,value1,[value2],...)

Example