Differences between totals calculated with BIRT and those calculated in MySQL

eranariel
eranariel
edited February 11, 2022 in Analytics #1
<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>

Comments

  • micajblock
    micajblock E
    #2
    <p>Can you share the design? Or even better reproduce this using a flat file? Rounding errors should not cause such a huge difference.</p>
  • SailRCG
    SailRCG
    #3
    <p>Eran, </p>
    <p> </p>
    <p>This is usually due to either a BIRT Grouping definition, Aggregation in a Data Binding, or even a filter inadvertently applied. The best thing to do is to validate the data in Data Previewer. If it matches exactly with what you get when you execute in MySQL then, it will match in the report design; keeping in mind the three common areas of disconnect when comparing a SQL aggregation to a Report aggregation. </p>

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs