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

[maxgro]

for the sum(....) expression

choose a number format in number tab

[sunny_talwar]

Are you asking why is this happening? or looking for a solution for this??

Possible solution -> Num(Sum(QUANTITY_RETUR), '#.###')

[parthakk]

try explicitly setting number of decimal to expression.. it shall reflect in your total value as well

[#5]

Hi Massimo,

I dont want to change the number format. I am using expression default for number format. Decimal number must be the same with each data.

Do you know why ?

thanks

[#6]

Hi,

If there any value having the more decimal precision, then it will reflect in total. Use explicit number format for field.

[maxgro]

if you use expression default (left) you get different number of decimal

if you use a fixed format (right) in number tabb or you format the expression (num(sum(field), '#.##0,00') you get the same number of decimal for all values

or I'm missing something?

[#8]

Hi Massimo,

Yes, your left image your data is 12 decimal. but my data for each header and line have 3 decimal. So it must be the sum/total is 3 decimal also.

Thanks for your reply Massimo.

[#9]

Can you post your sample data or how are calculating your quality field values?

[#10]

Hi Sindhu,

Sorry i cant Sindu. I only use sum(quantity) for the expression. and add three dimension (week, header_id, and line_id).

Data for each header and line is OK with 3 decimal, but the total is more than 3 decimal. Really confuse about it.

Thanks.