Report Builder Rounding Totals

[jaybears130]

I'm building a paginated report in Report Builder and I have to sorting groups (Group 1 and Group 2).  I have a field within the dataset called "Gross_Total."  The report is related to construction values broken down by the two groups mentioned above.  For the purpose of this post I'll provide names of each group and refer to them in that way moving forward.  Group 1 is "Building Location" and Group 2 is "Work Scope."
What I'm doing in the report is sorting by Building Group and then the detail underneath that is Work Scope (note: work scope actually represents the subtotal of all items in my dataset for that particular work scope.  For instance, there is a Work Scope called "Concrete" that, if I had all details in the report, would encompass about 20 items all related to Concrete.  So my report is a recap of the total value of each Work Scope sorted by Building Location.

The problem I'm running into is that I'm rounding the Gross_Total for each Work Scope as well as rounding the Gross_Total for the Building Location and the math isn't working out perfectly because the Gross_Total for the Building Location isn't actually calculating off the rounded values from the Work Scopes.  It appears it's just taking the value of that field (Gross_Total) from the dataset and just rounding that.
How can I get the report to take the rounded values from that Work Scope sort and do the math within Report Builder?  I hope that all makes sense.

[samanthamasoni]

Hi! I have found the answer to this. I had a bunch of fields I needed to round up for pallet counts (pallet counts always has to round UP because you cant have .5 pallet), but I kept running into the issues of my totals summing the NON rounded value, making my total to 9.4 instead of 10. SO, what you need to do is highlight the specific data cell and press expression. Erase aggregate and use ROUND(SUM(Fields!, (Whatever fields you need to round). I kept on doing Sum before Round and it needs to be =Sum(Round(Fields!Sales_20_Order_20_Line_20_Metrics_x_23__20_Est_20_Pallets.Value)). Hope this helps!

[Anonymous]

Hi, @jaybears130 

It is difficult to understand what your needs are and what the steps are to realize your needs just based on your textual description, can you provide screenshots of relevant non-sensitive information and corresponding textual representations to describe your problem. Thank you for your understanding.

Best Regards,
Yang
Community Support Team