NPV (Net percentage value)

[Rajsd]

Hi,

    How can we convert the following function from Excel to qliksense.

=NPV(0.1, value1, value2 , value3)

If i do sum of value1,Value2,value3 in qliksense,its not giving right values! 

Kindly help

[Ksrinivasan]

hi,

good,

my dummy data

Result: expression details in screen

ksrinivasan

[Rajsd]

The values are not right,

I tried with values in the following link but its not right.

https://corporatefinanceinstitute.com/resources/knowledge/valuation/npv-formula/

Here thr values are 10,12,8,16 with 12% ,it should come 34.4 but if do with the logic u provided i am getting around 41! 

 

 

[Ksrinivasan]

hi,

Try in excel as you have mentioned in earlier example.

Ksrinivasan

[Rajsd]

Ya i tried in excel, its working fine. So this is my actual question! How can we convert this in qliksense!

[Ksrinivasan · Accepted solution]

hi,

find the screen:

measures is : Val1/1.12+Val2/(Pow(1.12,2))+Val3/(Pow(1.12,3))+Val4/(Pow(1.12,4))

ksrinivasan

[Rajsd]

Thanks Man, Appreciate ur efforts!!! Will try this using my data👍