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.
Printable View
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.
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
Thanks! It works!