Number of decimals in sum function

[arfo]

This seems to be the easiest thing, but I cannot find any information on this.

I have a table with a number field Kellyfraction.



SELECT kellyfraction FROM ddbets;
displays the values as expected with as many decimals as they are stored.


SELECT Sum(kellyfraction)FROM ddbets;
displays the sum rounded to two decimals.

How do I get the result of teh sum function to be displayed with the number of decimals to my liking?

[RuralGuy]

My search says the results vary depending on the input and expand when needed. It shows no rounding involved.

[arfo]

Attacking screenshots to illustrate the problem.

[RuralGuy]

I see the problem. How about zipping up a sample db and posting it so we can play with it?

[arfo]

That would be most kind of you.

[arfo]

anyone have a clue?

[weekend00]

because the total is exactly 0.030000000