Problem with Decimal Precision

[#1]

Hi,

I have a question. I have a straight table with one dimension (week). i want to show total quantity, so i write the expression with sum syntax. But the total value has different decimal precision with the data itself (3 digit precision).

this is my table.

each data has 3 digit decimal, but the sum(quantity) has many decimal.

Really appreciate your help.

Thanks

[sasiparupudi1]

hi

Why cant you use the expression as suggested by Sunny T ?

num(sum(QUANTITY_RETUR),'#.##')

[swuehl]

Well, you think, that each value has no more than 3 decimal places, and the sum therefore shouldn't show more, but you only see a decimal view of internal binary representation:

Rounding Errors

If you want to show no more than 3 decimal places, use a formatting function (e.g. in the expression, then you can use expression default).