Page 1 of 1

Rounding

Posted: Fri May 06, 2016 11:27 pm
by laducd
Is it possible to round numbers to the nearest thousand or million?

What I would like to do is take a value such as 17,740,000 and round it to 17,700,000?

thanks

Re: Rounding

Posted: Sun May 08, 2016 12:36 am
by Ivan
Hello,

You can use the following expression, for example:

Code: Select all

{Round((double)your_value/100000)*100000}
Thank you.