<p>I have a accuracy issue when calculating subtotals. The numbers I bring into BIRT are decimals with 2 decimal places. When calculating a subtotal of sales from 164,000 records, the difference between calculation in Birt and that using the SUM(my_column) function in MySQL is $30,000.</p>
<p> </p>
<p>When calculating using Excel or Calc, I do not experience this discrepancy.</p>
<p> </p>
<p>Is this a number type issue? Please advise and thanks in advance,</p>
<p> </p>
<p>Eran</p>
<p> </p>
<p> </p>
