Skip to main content Skip to complementary content

RangeNPV - script function

RangeNPV() returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and incomes (positive values). The result has a default number format of money.

For cash flows that are not necessarily periodic, see RangeXNPV - script function.

Syntax:  

RangeNPV(discount_rate, value[,value][, Expression]) 

Return data type: numeric

Arguments:  

  • discount_rate: The interest rate per period.
  • value: A payment or income occurring at the end of each period. Each value may be a single value or a range of values as returned by an inter-record function with a third optional parameter.
  • Expression: Optional expressions or fields containing the range of data to be measured.

Limitations:  

Text values, NULL values and missing values are disregarded.

Example 1:  

RangeNPV(0.1,-10000,3000,4200,6800) returns 1188.44.

Example 2:  

Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.

RangeTab3:

LOAD *,

recno() as RangeID,

RangeNPV(Field1,Field2,Field3) as RangeNPV;

LOAD * INLINE [

Field1|Field2|Field3

10|5|-6000

2|NULL|7000

8|'abc'|8000

18|11|9000

5|5|9000

9|4|2000

] (delimiter is '|');

The resulting table shows the returned values of RangeNPV for each of the records in the table:

Example results
RangeID RangeNPV
1 $-49.13
2 $777.78
3 $98.77
4 $25.51
5 $250.83
6 $20.40

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com