Is the first parameter of the XNPV function a field or a constant?

christian77 — Sat, 16 Nov 2024 21:44:50 GMT

Hi all.

To see my point better, refer to this site:

[https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FinancialAggregationFunctionsInCharts/xnpv.htm]

FIRST

The example shown is wrong. The calculation way is wrong. The result is wrong.

They are all wrong for the same reason.

This example in the help menu must be reviewed and temporally hidden. It is confusing people.

Cashflow:

LOAD 2013 as Year, * inline [ ///it’s wrong, last date’s year is 2014

Date|Discount|Payments

2013-01-01|0.1|-10000

2013-03-01|0.1|3000

2013-10-30|0.1|4200

2014-02-01|0.2|6800

] (delimiter is '|');

The function is: Xnpv(Discount, Payments, Date). Net Actual Value of a rent

If I do that with a fixed interest, discount of 10%, that is 0.1, the result is 2967.63 $.

If I do it in excel with the same parameters (VNA.NO.PER), the result is also 2967.63 $.

In the example, it says -3164.35 $. Its wrong, it can’t be negative. If the interpretation is ‘read it positive’, it’s wrong too because the last payment has a bigger discount therefore the actual net value is smaller.

In any case its wrong and needs to be reviewed or maybe explained, for me to understand.