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.

[Gysbert_Wassenaar]

If i perform normal sum

What does this mean? Are you summing the rounded values in excel after exporting the table from Qlikview to Excel? There's no fixing that issue if that's the case. Either don't round the values you export to excel or don't sum rounded values in excel.

[satishkurra]

Hi

Thanks for the response.

Attached is the file without rounding, I'm seeing the same result as before.

!

[Gysbert_Wassenaar]

Are you using dimension limits in the straight table? If not please post the qvw document so we can see what's going on.

[satishkurra]

Attached is the sample app where i'm expecting 468.9 or 469. But Total is 472.2

[Gysbert_Wassenaar]

The expression you're using gives a different result at the chart level then the sum of the row values. It's not a straightforward sum, but the product of a sum and a count divided by another sum. Change the Total mode of the expression to Sum of Rows and you'll see the result you expect.

[satishkurra]

Thanks

This is working in straight table. How about displaying the same number in Bar Chart and Pivot Table?

[Gysbert_Wassenaar]

Sum(aggr( ...original expression here... ) , ...Chart, Dimensions, here... ))

[satishkurra]

Unfortunately my bar chart does not have dimension. Please help in this case

[Gysbert_Wassenaar · Accepted solution]

Then decide over which dimension(s) you think the original expression should be aggregated. My guess would be the dimensions of the straight table.