Thursday 21 September 2006 @ 10:11 pm
A former student was having trouble adding decimals to the cells of his cross-tab and asked me why. After doing some research I found a problem that I had not noticed before. Cross-tab summaries of Count and DistinctCount that do percentage of total calculations are always truncated to an integer (not rounded). This means that they will not total correctly to 100, although the 100 appears as the total. Worse, there is no way to show more decimal places. This affects v9, v10 and XI but goes away in CR 2008. in V9 you can add decimal places easy enough but they are always zeros. In 10 and XI you can’t even add the decimals.
For more information on using percentages in Cross-tabs see my related newsletter article
You didn’t mention above that you can use your running total method for creating percentages in crosstabs, and when writing the formula in the display string formula area for the “holder” summary, you can specify the number of decimal places, as in:
I have recommended this method for this very reason.