Im having trouble with a running sum for my VAT analysis section of a report.

Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this.

So i have following figures
245.70 at 21% which is 51.597 when rounded goes to 51.60
120 at 21.5% which is 25.80 with no need to round
382.20 at 13.5 which is 51.597 when rounded goes to 51.60

i want it to add the rounded figures so so 51.60 + 25.80 + 51.60 =129.00. So it looks OK on the report

Instead it is displaying 128.99 which is rounded from 128.994 since (51.597 + 25.80 + 51.597) = 128.994

Any help on the issue is much appreciated.

2
Contributors
1
2
Views
8 Years
Discussion Span
Last Post by boblarson

Im having trouble with a running sum for my VAT analysis section of a report.

Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this.

So i have following figures
245.70 at 21% which is 51.597 when rounded goes to 51.60
120 at 21.5% which is 25.80 with no need to round
382.20 at 13.5 which is 51.597 when rounded goes to 51.60

i want it to add the rounded figures so so 51.60 + 25.80 + 51.60 =129.00. So it looks OK on the report

Instead it is displaying 128.99 which is rounded from 128.994 since (51.597 + 25.80 + 51.597) = 128.994

Any help on the issue is much appreciated.

Try using the ROUND function on the control source of the text box that you are using for the running sum.

Or use the Round function in the query itself.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.