I have a value say 12345678. I need to divide this by 1000 and the result should be 12345.68. How to achieve this Crystal reports? Here's what I tried: Round({value1} / 1000, 2)

CodePudding user response：

The expression Round(12345678 / 1000, 2) in Crystal returns 12,345.68

Please clarify: in what way the result you get is not what you want?

CodePudding user response：

Its not enough to just format inside formula field. You need to set object Format to Number and set its precision.