I have a table , in each cell there are different numbers.
I use this query to make the sum of this mathematical formula withing the SUM brackets
SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)*1.005)
Where date BETWEEN '2006-10-03' AND '2007-01-01';
Ok the problem is that after 20-30 records , the sum is correct , but after that there is a high declination of the actual sum. (i tested that by hand to see the accuracy of the sum ).
So after i tried many things , i end up to the conclusion that the sum funcion rounds the ratio (kinisis_1c / kinisis_1b) , and causes the above problem of declination from the actual sum of those numbers.
Thats why i search a way to bypass this problem :( if there is any way ofcourse.