title: SQLite SUM function rounding error - android
body: <p>Why is it that when I call a <code>SUM</code> on one of my SQLite columns, it doesnt return a precise answer? Heres what I mean:</p>
  
  <p>Lets say I have 4 rows in my column to sum</p>
  
  <pre><code>row1      8362.82
  row2     +18837.42
  row3     +7294.12
  row4     +73.23
  ___________________
           17567.59
  </code></pre>
  
  <p>Now these should add up to <code>17567.59</code> right? Well my <code>sum</code> returns <code>17567.6</code>. This may not sound like a big deal but I need accurate decimals, not rounded ones. It rounds further as the numbers get larger too. Can anyone explain a solution to this? Thanks.</p>