Rounding to the nearest hundred

StephBell-Mercer · Post by **StephBell-Mercer** » Fri Aug 12, 2011 1:47 pm

How can I round to the nearest hundred in the report writer?

Brainstorm · Post by **Brainstorm** » Fri Aug 12, 2011 1:54 pm

Not sure if helpful but give it a shot:

decimal Round (decimal value, int decimals)

Rounds a decimal value to the nearest integer.

Parameters
value - A decimal number to be rounded.
decimals - The number of significant decimal places (precision) in the return value.

Return Value
The number nearest to a value with a precision equal to decimals. If the value is halfway between two numbers, one of which is even and the other odd, then the even number is returned. If the precision of value is less than decimals, then value is returned unchanged.

Post by **HighAley** » Sat Aug 13, 2011 6:22 am

Hello.

StephBell wrote:How can I round to the nearest hundred in the report writer?

Please, try to use this expression:

Code: Select all

{Round(YourDataSource.YourTextField/100)*100}

Thank you.