March 19, 2013 at 12:05 pm
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?
Thanks, John
March 19, 2013 at 1:33 pm
sorry meant to post this in 2008
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply