OK - I've tried everything I can think of to fix this but nothing is working. Here's the issue; I have created a report that is sums building square footage grouped by market. the client wants the excel export in whole numbers so I put in a round function, with and w/o midpointrounding.away fromzero and then tried (format N0) each returns the whole number. So far so good. However when I total the group the value is sometimes spot on and sometimes off because of the rounding. I tried rounding the group total, etc., but no combination of rounding/formattting seems to work. I thought of going into the underlying sql and create a new dataset for the totals, but not sure that wouldn't have the same issue, besides it is a pain given all the colums subtotals and totals I am dealing with. Anyone else encountered this? How did you solve it?