Decimal Precision Problem 1

[JCiesielski]

Im using Crystal v10.
I have a report that calculates a percentage based on 2 summary fields. The Formula is (1.09/25285)*100 and the result should be .004% Unfortunately, the report only shows 0.00000. I have tried allowing more decimal places, converting the numbers to doubles, and removing field clipping. If I change the 100 to 1000, it returns .04 so I know the rounding problem is at this formula. Is there any way to get a higher number precision?????

 

[kskid]

From the Design Canvas, right click on the formula->Format field. From the number tab, click on Customize and select 1.000 for your decimal. It's probably set to 1.00

Cheers,
-lw

 

[JCiesielski]

Tried it, its set to 1.0000.

 

[JCiesielski]

Fixed it, I had the rounding set too low.

 

[MrBillSC]

Under format / customize set rounding to .001 and set decimals to 1.000

MrBill

 

[Madawc]

What about (1.09*100)/25285? Or allow for more decimal places.

Madawc Williams (East Anglia, UK)

 

[Madawc]

Sorry about my late (and now irrelevant) reply. The two entries above it were not visible to me just a few minutes ago.

Madawc Williams (East Anglia, UK)