Error in showing 'percentage of count'

[peterb58]

CR XI on Sybase 11.

I have a report which displays some group totals as percentages of the whole.

I have used the summary editor to show 'percentage of count'

The problem is when I want more precision. One of the groups will show an error when it is between 1% - 2%.
Using 2 decimal places it shows 1.#J.
At them moment with 4 decimal places it shows 1.#IND
I have played with various combinations of Rounding and Decimal places to no avail.

Anyone know what is happening.

thanks

 

[Madawc]

I've never seen anything like this error. My best suggestion is that you try another method. Create a formula field and edit the values using ToText. Something like

ToText({summary.total}, 2)

If necessary, re-create the summary totals from scratch.

Incidentally, are you defining the summary totals yourself? That could be the cause. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[peterb58]

Madawc

I noticed that for an unknown reason, some of the automatically calculated summaries were incorrect.
For instance one summary had a value of 238001000 and when divided by the small number I was using produced these 'errors'.

I suspect they were actually attempts at showing very small number in power of -n range.

These were standard summaries created using the Insert Summary icon.

I have since created the summaries manually and everything works OK.

Thanks

 

[Madawc]

I don't think the functions actually fail. If you get an unexpected answer, then something is not as you thought it was. Data, for instance. Do by stages and show intermediate data, something unexpected will turn up.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP