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.

Have you tried Round (number; 2) ?

Thank you,

Jason

Edited April 13, 200718 yr by Guest