I have a problem with dollar amounts when using calculations. I have an order total field which is a calculation to total up items on an order, shipping and sales tax. Then I have an amount paid field. And finally I have a total outstanding field that subtracts the amount paid from the order total. I have found though that because the order total is formatted down to two decimal places depending on the math I might end up showing a -$0.01 total outstanding even though the order total and amount paid are equal.

So I want to find a way to round to two decimals, not just format a field to only show 2 decimals. Does that question make sense?

Thanks in advance.

I think I found my own answer. The Round function will do it.

Sorry for the unnecessary post.

Chris,

For sure try the rounding function. I have still found that while running reports, it is possible for them to be +or- .01 due to fractions of pennies (certain refunds or prorated items etc). No biggie but I tore my hair out for a while trying to find out where that penny was.

I contacted FM quite a while ago and they told me that FM doesn't like handling rounding calculations (or something like that.... it's been years since that time).

Mike