Rounding to the nearest Million
Posted: Tue Nov 24, 2015 9:46 pm
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
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