Rounding Formula 2

[elf1]

I am wanting a field to round up to the next hundredth(.00) if the next thousandth(.000) is .001 on greater. I am not sure how to write the proper rounding_type formula for this to happen. Any help on this would be much appreciated.

 

[paulmarr]

if {db.field} > .001 then
Round({db.field},3)
else
Round({db.field},2)

 

[lbass]

Try:

-int(-{table.field}/.01)*.01

-LB

 

[elf1]

the formula -int... worked perfectly.

Thanks a ton