CODEWITHSUNDEEP
crystal-reportsdecimalrounding
Roby G.
Roby G.

Reputation: 105

Round decimals in report formula

My Crystal Report needs to round numbers to two decimal points. I have tried Round(55.815, 2) but it returns 55.81 instead of 55.82. How can I resolve this?

Upvotes: 2

Views: 25745

Answers (2)

user3150744
user3150744

Reputation: 34

just try this if Remainder(55.815 ,1) > 0.5 then Floor (55.815) + Remainder(55.815 ,1) else Floor (55.815 )+ Remainder(55.815 ,2) This may be help you

Upvotes: 1

craig
craig

Reputation: 26262

If you need to round the decimal for display purposes, simply use the "Decrease Decimals" icon:

enter image description here

Upvotes: 4

Related Questions