>Hi everybody,
>
>We have a table based on which we calculate commissions for the sales people. This table has field Rate 9.7
>
>In our calculations we're using another table with the Rate field 5.2 and in all calculations we first update Rate field in that table and then use that Rate in our calculations losing several digits.
>
>I mentioned it yesterday to my boss and he told me to try to use the whole rate.
>
>Now I compared data between old and new program on production data and found a difference in more than 2K. I guess, I better return to the original way of calculation then...

You could update your application to use a new calculation, but during the update replace ALL old RATE field with the actual value (5,2), so for old time you will have the same values, but from now on you will calculate better.