Rounding....up [RESOLVED]

[Joffies]

Hi all.

I would like to round a figure in the following way! Say i have values like $ 1.444 and $1.351 i would like to always round the up the third decimal no matter what! How could i achieve this in crystal reports ver 8.5. many thanks.

[brucevde]

You could create a formula which adds .005 to the database field. This way rounding will work the way you want.

For example

1.444 + .005 = 1.449 = 1.450
1.351 + .005 = 1.356 = 1.360

[Joffies]

Thanks! It works!