rounding issue

[davyqliks]

Hi,

I have a simple expression taking an item value and multiplying by the stock in house:

0.2925 * 8000 = 2340 (correct)

0.0281 * 19700 = 553.57 ( 554.11 in QV ) odd rounding!

Can anyone explain why the 2nd example is not correct?

I have tried floor and ceil but no joy!

I am simply using 

[UK Stock in House] * [UK EFP]

and have tried

Floor([UK Stock in House] * [UK EFP])

Ceil([UK Stock in House] * [UK EFP])

I know the difference is negligible but i really want this to be exact.

Thank you in advance if you can assist.

Daniel 

[Kushal_Chawda · Accepted solution]

@davyqliks  AFAIK, qlik does the rounding correctly. Values totally depend on what expression your using and underlying data. Probably you can provide the sample file to look at. Meanwhile try below

sum([UK Stock in House] )* sum([UK EFP])

[davyqliks]

Thanks Kush 🙂