Jump to content
Sign in to follow this  

Precentage Rounding Problem

Recommended Posts

The problem I am having is when I am trying to get a percentage of a dollar amount, the percentage never rounds up or down. Even when I tell FM not to go more than 2 decimal places it always goes 3, 4, or 5 places.

The database I am working with is for figuring out what to pay our sub-agents, but we cannot use the database properly without it multiplying correctly. The agents always get paid more and we cannot have that.

Thank you for your help.

Share this post

Link to post
Share on other sites

Have you tried Round (number; 2) ?

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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