topic Re: Numbers not calculating in QlikView

Numbers not calculating

mcoetzee — Wed, 25 Nov 2020 16:16:04 GMT

Please see formula that does not want to work, please help?

if(DiscountValue>0, sum((DiscountValue / 1.15)/PaymentFreq),0) + (MasterTotalExc/PaymentFreq) AS FinalNewMonthlyFee

m_woolf — Mon, 15 Apr 2019 13:43:20 GMT

Try:

if(DiscountValue>0, (DiscountValue / 1.15)/PaymentFreq),0) + (MasterTotalExc/PaymentFreq) AS FinalNewMonthlyFee

mcoetzee — Tue, 16 Apr 2019 06:58:47 GMT

Hi,

It is not calculating the discount amounts with.

arpitkharkia — Tue, 16 Apr 2019 12:24:16 GMT

May be try this

if(DiscountValue>0, sum((DiscountValue / (1.15*PaymentFreq),0) + (MasterTotalExc/PaymentFreq) AS FinalNewMonthlyFee

mcoetzee — Tue, 16 Apr 2019 12:27:03 GMT

Thanks, its working.