Formatting decimal places in percentage.

[terenceb]

Hi All,

I am using Crystal 8.5 pulling data from sql tables from a cashe database. I need to format my percentage out come so that when I divide 4478 by 3 the answer is 0.14 not 1493. I have divide my out come by 1000 but that will not work with every situation.

 

[kchaudhry]

You can do the following:

Right click on the formula which you created then
Format > Number > Customize > Select the appropirate rounding.



Kchaudhry

 

[Madawc]

Why is dividing by 1000 failing? If you want 1493/1000 to come out as 0.14 rather than 0.15, then use
Truncate(@your.value, 2)

Truncate is a near function, you could also turn 1493 into 1400 using Truncate(@that.value, -2)


Madawc Williams
East Anglia, Great Britain