Rounding

[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

[Ivan]

Hello,

You can use the following expression, for example:

Code: Select all

{Round((double)your_value/100000)*100000}

Thank you.