Qlik Sense Tutorial | Qlik Sense Script and Chart Function - NPV() Financial Function
NPV() returns the aggregated net present value of an investment based on a discount_rate per period and a series of future payments (negative values) and incomes (positive values), represented by the numbers in value, iterated over a number of records, as defined by a group by clause. The payments and incomes are assumed to occur at the end of each period.
Like what I am doing? Buy me a Coffee to re energize - https://tinyurl.com/txe98jf
datasets - https://tinyurl.com/yd65vnf3