Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Partner - Specialist

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

Hi all.

To see my point better, refer to this site:

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.

SECOND

The question is:

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

Xnpv(Discount, Payments, Date)

If I do it with a constant it works. Otherwise it does not.

Please, tell me if it is possible to calculate this function with a variable discount rate

Thank you very much to everyone who has read this post.

Thank you very much to the workers of the community and help menu.

Thank you very much to those who I haven’t mentioned before.

Labels (1)
• ### Financial functions

2 Replies
Partner - Specialist
Author

Nobody?

Specialist II

The discount rate must be a unique value (the same way Excel would work)

When you have multiple discount rates the calculation is more complex; not sure how easily it can be done in Qlik Sense