Rounding issue: Incorrect result when dividing in a calculated field

Question & Answer
1

Hi,

I am having an issue when I simply want to divide a field by 1000.
I am have a field let’s say weight with a value of 0.1230.

I created a calculated field weight (t) : {weight}/1000. It returns 0.000100 instead of 0.000123.

How can I fix that ?

Thanks for you help!

2

Hi @Elope -

Thank you for raising this issue here.

You can use this as a workaround.
({weight}*1000)/(1000^2)

Example:

image
image761×106 3.95 KB

3

The trick works! Thank you for you help.

2 Likes
4

Hello. I have a similar issue, but I have to multiply by 10000. Problem is when I use this fix I get the error: “Amazon QuickSight encountered an overflow error while performing multiplication”.

Any suggestions?