Aggregation fuction SUM do not work properly

avujic

<p>I have report that sums up some values. I am using data type FLOAT because I am summing amounts.</p><p> </p><p>Problem is, if sum of amounts is bigger than 1 000 000 (seven digits) it inserts E in result.</p><p> </p><p>Example: sum is 13 000 000</p><p>               result is 1.3E7</p><p> </p><p> </p><p>Can someone tell me how to prevent this from happening?</p><p> </p><p> </p><p>In attachment, you'll find specific aggregation builder.</p>

hvb

<p>What kind of amounts?</p><p>If it is it a scientific computation, then float is ok, and 1.3E7 is ok as well.</p><p>If it's about money, you should use Decimal instead of float.</p>