Numbers not calculating

[mcoetzee]

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]

Try:

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

[mcoetzee]

Hi,



It is not calculating the discount amounts with.

[arpitkharkia · Accepted solution]

May be try this

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

[mcoetzee]

Thanks, its working.