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.
IP Logged