Field formula rouding

#1

Hi Folks !,
I’ve got a field formula that takes a number from a previous field and divides the number by 6160…
example…
field(“Tonne Miles”)/6160

The calculated field rounds up to a whole number and I wondered if you knew how to preserve x number of decimal places.
I’ve tried changing the decimal places on the field but it doesn’t change the value.

Hope you can help
Nick

#2

Ruby automatically casts the result to an integer when both operands are integers. To preserve the decimal places, simply make the denominator 6160.0