Forum Discussion
Report Builder Rounding Totals
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 v...
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!