Rounding issue: Incorrect result when dividing in a calculated field


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!

Hi @Elope -

Thank you for raising this issue here.

You can use this as a workaround.


The trick works! Thank you for you help.


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?