Rounding to the nearest Million

[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

[Alex K.]

Hello,

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

Thank you.

[laducd]

Thanks, that worked.

[Andrew]

Hello,

Great! Thank you for letting us know about this.