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!

Rounding issue: Incorrect result when dividing in a calculated field

robdhondt July 12, 2022, 4:44pm 2

Thank you for raising this issue here.

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

Example:

Calculation: Correct input, wrong output. why?