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. In all cases there is a kludgy workaround described in a white paper that you can download form BO’s website.
For more information on using percentages in Cross-tabs see my related newsletter article