Stop Crystal Report From Rounding

[FLD2008]

I'm relatively new to Crystal report and I've created a report that needs Crystal 10 to stop rounding.

I want the value displayed to be only 2 decimal places. For example if the value is:

a) 83.3333 it will display 83.33
b) 78.125 it will display 78.13 <---I want it to only display 78.12.

I believe this requires a formula, however I do not know where to approach this. Could someone give me some pointers please?

Thanks.

 

[Madawc]

If you right-click and chose field format, you can control both the rounding and the number of decimal places shown.

Or you can put it in a formula field.

Truncate({your.value}, 2)

Means 1.339 to 1.33. The alternative would be

Round({your.value}, 2)

Means 1.735 to 1.74

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[FLD2008]

It worked. Thanks!!