Sum of total Error in Qlik sense

[manishapanda1]

Hi Friend,

I am applying the below formula to get total sum of the below values 

NUM(SUM(RANGESUM([t17.HH],[t18.HH],[t19.HH],[t20.HH],[t21.HH],[t22.HH],[t23.HH],[t24.HH],[t25.HH],[t26.HH])))

While performing the sum of total value is coming 18284384 in Qlik Sense and  sum of total value is coming 18284124 while performing in Calculator /Excel .i have applied the same formula to the whole table but for few columns i am getting this problem.

[t17.HH]	1027
[t18.HH]	100169
[t19.HH]	22721
[t20.HH]	0
[t21.HH]	18160207
[t22.HH]	-
[t23.HH]	-
[t24.HH]	-
[t25.HH]	-
[t26.HH]	0
correct sum	18284124
Qlik sum	18284384

Need your valuable suggestion .

Thanks,

Manisha 

[tresesco]

Could you share an app that replicates the issue?

[manishapanda1]

Thanks for replying , but i can't share app the data is coming from Vertica database , i thought  due to decimal values total value is coming different , but for  for few other columns the value is more different eg if in qlik it's 634567 then in excel sum  total values is 625784 and this problem occurring for few columns only rest all columns are working fine with same formula.