How to Round numbers?

Discussion created by dchabot on Jan 25, 2012
Latest reply on Jan 26, 2012 by comment

Good day to all.


I have a payroll database and am really struggling with rounding of numbers.

The calculations involve the usuall fed, fica etc.


If the fica calc is .042 * Gross Pay, should I round that calc to three, and then when the paycheck is created,

do I round that number to two?


I had all the beginning calculations rounding to the largest number of digits needed

and in paychecks rounding to 2.


Or should I round everything to two from the start?


What I'm finding is the net pay, of all things is not coming out???

Gross Pay - Fed - Fica - State - Deductions = Net Pay (but net pay is always off)

It's always off 4 cents. The taxes and deductions seem perfect, so I'm stumpted.


Does Filemaker go about this differently?


For example if I round the full digits, all the way through to paycheck, and then have paycheck 'show' only 2 digits, it works.


You'd think I answered my own question, but I have to wait until next payrun to see if my statement works.




Message was edited by: dchabot I can't see where I can make this post a question so I can give ratings to the wonderful people that help me????