Rounding down if last decimal place is 5

[helenv]

I want to round a number field to 2 decimal places, but instead of rounding up if the last digit is a 5 i'd like to round down.

SO, 123.766 would be 123.77
and 12.521 would be 12.52
but 65.325 would be 65.32

any ideas? I was thinking maybe some kind of formula that looks at the last digit? The number is a database field which always has 3 decimal places (I think)...

Thanks

 

[helenv]

Ah, I have tried:

if remainder({report.basic_item_price},0.005) = 0 then Truncate ({report.basic_item_price},2)
else ({report.basic_item_price})

and this seems to work. Does that look right?

 

[dgillz]

round({yourfield},2) should work fine.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com