>>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.

I don't think we can alter that table... Also it looks like we were paying less commissions than my new way would make, so perhaps it's even better for the business to use the old style calculations and lose digits on purpose.

I'm going to verify this issue again with my manager, but I guess I had to go back to wrong calculation to avoid questions asked.