Precentage Rounding Problem

[caseyuptobat]

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.

[mr_vodka]

Have you tried Round (number; 2) ?

[caseyuptobat]

Thank you,

Jason

Edited April 13, 2007 by Guest