Summary total that can sum the rounded values
Content
I have attached the report snippet where I am facing this challenge. Total Assets row is a formula row that basically sums the rows above it. All data values are scaled to the thousands. The client is expecting the Total Assets to be $308724 and that is what it is if you do the sum of above scaled values. But the report is doing a sum of the unscaled data from rows and then scaling it to the thousands which is causing Total Assets to be $308725. I am using Sum([5,19]), I tried Sum(Round([5,15]) however no success. I tried this and it
0