I created a calculated expression called Net Amount in my Qlik Object. In my calculation, I had to hard code in a dollar amount for accounting purposes. In the Qlik Object,The sum of my calculation does not equal my hard coding additions; however, when I export the same data to Excel (without changing anything), the sum in Excel is accurate.
I am getting two different numbers based on the same logic and same data, just different format (Excel export vs Qlik) .
Below is my logic ( note: I replaced account number with '########':
if([Account Number]='########','16630.88',
if([Account Number]= '########','27479.21',
if([Account Number]= '########','10104.76', I
f([Account Number]= '########','14105.80',
if([Account Number]= '########','21539.26',
if([Account Number]= '########','49515.28',
if([Account Number]= '########','4165.01',
if([Account Number]= '########','7344.20',
if([Account Number]= '########','14559.19',
if([Account Number]= '########','31985.66',
if([Account Number]= '########','59616.58',
if([Account Number]= '########','25750.54',
if([Account Number]= '########','10029.85',
if([Account Number]= '########','6795.16',
if([Account Number]= '########','6299.54',
if([Account Number]= '########','29263.95',
if([Account Number]= '########','5663.27',
if([Account Number]= '########','26439.93',
if([Account Number]= '########','9650.02',
if([Account Number]= '########','-489.54',
if([Account Number]= '########','42347.82',
if([Account Number]= '########','9986.49',
if([Account Number]= '########','9527.98',
if([Account Number]= '########','-2621.51',
if([Account Number]= '########','44766.83',
if([Account Number]= '########','24791.13',
if([Account Number]= '########','41405.90',
if([Account Number]= '########','66050.60',
if([Account Number]= '########','6730.27',
if([Account Number]= '########','1315.59',
if([Account Number] = '########', '-632.06',
if([Application Type]='IL' or [Application Type]='ML', Sum([Principal - Participated]) - Sum(UNEARN_DEFER_FEES_AMT)- sum(UNEARNED_DEFER_FEES_AMT) + sum(REMAIN_DEFER_FEES_AMT)+sum ([Defer_fee_bal_amt])+sum (Defer_cost_bal_amt) , sum([Net Loan Balance]) - Sum(UNEARN_DEFER_FEES_AMT)- sum(UNEARNED_DEFER_FEES_AMT) + sum(REMAIN_DEFER_FEES_AMT)-sum ([Defer_fee_bal_amt])+sum (Defer_cost_bal_amt), ))))))))))))))))))))))))))))))))
