Jump to content

This topic is 7358 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

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. smile.gif

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

This topic is 7358 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.