Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mcoetzee
New Contributor

Numbers not calculating

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

 

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

1 Solution

Accepted Solutions
arpitkharkia
Contributor III

Re: Numbers not calculating

May be try this

 

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

4 Replies
mwoolf
Honored Contributor II

Re: Numbers not calculating

Try:

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

mcoetzee
New Contributor

Re: Numbers not calculating

Hi,



It is not calculating the discount amounts with.


arpitkharkia
Contributor III

Re: Numbers not calculating

May be try this

 

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

mcoetzee
New Contributor

Re: Numbers not calculating

Thanks, its working.