Best way to do is leave the choice to end-user.

In our software for each of the mentioned taxes, we have a setting if they would like to roundoff.

Rakesh



>Hi all
>
>There are some complex tax calculations to be performed. For eg. Excise is calculated on an abatement provided value of the Maximum Retail Price (MRP) of a products. Two more taxes are then calculated on this Excise amount. Assuming the client is going to ROUND() at 0 precision - no decimal places.
>
>Qty * MRP = Amount
>3 * 560.1257 = 1680.3771
>
>Amount - Abatement % = Assessable Value
>1680.3771 - (1680.3771 * 25 / 100) = 1260.282825
>
>% of Assessable Value = Excise
>1260.282825 * 4 / 100 = 50.411313
>
>% of Excise = Education Cess
>50.411313 * 2 / 100 = 1.00822626
>
>% of Excise = S&H Education Cess
>50.411313 * 1 / 100 = 0.50411313
>
>Assessable Value + Excise + Edu. + S&H = still more taxes to be added :)
>1260.282825 + 50.411313 + 1.00822626 + 0.50411313 = 1,312.20647739
>
>Except Qty and MRP, where is it mathematically suggest (if I may say so) that ROUND() be applied so that decimals are removed and set to the nearest integer
>
>Please advise.