Calulation problem

[Ben Ball]

This must be simple...

I am doing a very basic calculation within an invoice table.

The figures Net Total: Calculates all the total prices. I show this as 2 decimal places. The tax is calclated.... also shown as 2 decimal places...

but when I add

The net total + tax .... the sum is rounded up from the actual figures up to 4 decimal places which results in what looks like an incorrect calculation....

in terms of 2 decimal places.

for example:

I want to show:

255.22 + 44.66 = 299.88

instead I am getting 255.22 + 44.66 = [color:red]299.89

obviously because the calculation is adding three or four decimals and rounding the figure up??

Is there any way of adding just the two decimals as per the format.

[IdealData]

Try this

Gross_Amount = Round(Nett_Amount;2) + Round(VAT_Amount;2)

[IdealData]

or possibly...

Nett_Round = Round(Nett;2)

VAT_Round = Round(VAT;2)

Gross = Nett_Round + VAT_Round

[Ben Ball]

Perfect... thanks very much.. both work fine

Ben