Page 1 of 1

Rounding to the nearest Million

Posted: Tue Nov 24, 2015 9:46 pm
by laducd
Hi,

I am trying to to round to the nearest millionth and I can't seem to get it to work. I am trying {Round(Myfield, 4)} but it is rounding my decimal places 4 numbers. For instance, the value in my column is 8,935,400.88 and this is returning 8,935,400.8891. I would like the formula to take 8,935,400.88 and convert it to 8. Please let me know if you need further detail. Thanks!

Best,

Dominick Laduca

Re: Rounding to the nearest Million

Posted: Wed Nov 25, 2015 8:32 am
by Alex K.
Hello,

Please try to use the following expression:
{Math.Floor(8935400.8891/1000000)}

Thank you.

Re: Rounding to the nearest Million

Posted: Mon Nov 30, 2015 4:38 pm
by laducd
Thanks, that worked.

Re: Rounding to the nearest Million

Posted: Mon Nov 30, 2015 5:41 pm
by Andrew
Hello,

Great! Thank you for letting us know about this.