How to Calculate NPV

[#1]

Hi,

I know this shouldn't be that difficult, but somehow, it is.

Here's the issue. I need to learn how to calculate a simple Net Prsent Value in Qlikview.

Total Costs - 1.279 mln

Cash Flows -

200k

233k

233k

233k

233k

rate - 20%

The answer should be a negative NPV of -609.7k.

I am not an expert in sql, so I am a bit confused.

Thanks in advance

Tom

[Clever_Anjos]

Sorry, never worked with this function