Page 1 of 1

Rounding to the nearest hundred

Posted: Fri Aug 12, 2011 1:47 pm
by StephBell-Mercer
How can I round to the nearest hundred in the report writer?

Rounding to the nearest hundred

Posted: Fri Aug 12, 2011 1:54 pm
by Brainstorm
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.

Rounding to the nearest hundred

Posted: Sat Aug 13, 2011 6:22 am
by HighAley
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.