Print Page | Close Window

Percentages not Tallying

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4562
Printed Date: 08 May 2024 at 5:25pm


Topic: Percentages not Tallying
Posted By: mikebird
Subject: Percentages not Tallying
Date Posted: 17 Oct 2008 at 2:48am

I need to fix a cross-tab which gives counted figures and totals them at the end of each row. Then, percentages are inserted by the tickbox feature underneath the count, into the same cell and totalled as 100% of course.

The user isn't happy because the individual percentages along the way don't always add to 100% - sometimes 99% or 101% and I cannot see why. I've fiddled with row / column options - only the column option is meaningful. Can I increase the accuracy? Not the decimal places - doing this just gives .0000, no more accuracy. I think more accurate figures are to do with what's stored in the tables. Why do some rows get 1% out? What can I do? It looks bad.


-------------
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead


Print Page | Close Window