Rounding Issue in Total

[satishkurra]

Hi

I have the attached data created in a staight table in QlikView. If i perform normal sum, it is giving me 469.4, whereas the total is giving me 472.2

Can you guys help me in fixing this issue.

The expression in my report is Round(Sum(MyFieldName),0.1). The Number format is expression default.

[satishkurra]

Thanks for the help. I will use the lowest grain level dimension.

Also thanks for reminding me this sum of rows issues which i forgot long back:)