Running Sum Issue

[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.​

 

[DCrake]

Are you just summing the field by name or are you summing the rounded value?

Sub total = Round(Sum([Field]),2)

or

Sub total = Round(Sum(Round(Field,2)),2)


David

 

[MarcusMaximus]

Sorted it i was using the Format property(Euro) and the decimal places property(2) to get the values rounded.

I just =Round([txtVatCost],2) and have the running sum property set to over group and its working thanks for the help

 

[MarcusMaximus]

I couldn't find any tool to make as solved but consider this solved