Truncating Numbers

[FJquestioner]

I'm creating an accounting database.

I'm running into trouble when I calculate totals such as the amount I owe
on several bills.

The system stores data to several decimal places and calculates totals based
on these amounts rather than the rounded amounts (to 2 decimal places) that
are acutally displayed. Example:

Displayed Stored in System
Add this $ 2.00 $ 1.995

Plus this $ 2.00 $ 1.995

Totals this $ 3.99 $ 3.99

Does anyone know how can I get the system to store all calculated monetary
fields to 2 decimal places, rounded. Or another way to resolve this issue?

Thanks




I have all monetary fields set to the "Currency" Data Type.

Most invoices consist of a units * price

 

[FJquestioner]

Thanks a lot Gary for the quick and helpful solution. I tried it on a couple
of formulas and it worked like a charm.

Much appreciated.