Member Avatar for MarcusMaximus

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 Reply
  • 164 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by boblarson
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.