Round to the nearest even number

[jvolden]

Hello, we are useing Crystal Reports XI and are looking for a way to round to the nearest even number, similar to the CLng function in Visual Basic Scripting.

For example if the number was .5 it would round to 0 and if it was 1.3 it would round to 2.

Does any one know of a similar function in Crystal or have an idea on how to make this work?
Thenk you.

 

[shakespeare5677]

I would say create a custom report function that rounds to an even number.

 

[lbass]

Try:

if remainder(truncate({table.number}),2) <> 0 then
truncate({table.number}) + 1 else
truncate({table.number})

-LB