CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2008-r2ssrs-2012reportingservices-2005
UpwardD
UpwardD

Reputation: 767

Rounding Issues with Totals in SSRS

I have details figures like these: 

  Sales Amount
  £285.00
  £16,249.51
  £345.68

But the total returned was:

  £16,880.18

while I was expecting:

  £16,880.19

This is supposed to be the sum of details but the last digit is being rounded. How do I overcome this limitation?

Upvotes: 2

Views: 1707

Answers (1)

niktrs
niktrs

Reputation: 10066

Since your round your detail in the second decimal digit you can use the following expression (change the field in the expression to match your own)

Sum( Round(Fields!val.Value,2))

Another option could be rounding your dataset in your SQL code

Upvotes: 2

Related Questions