Percentages in Cross-tabs that do not round correctly

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








One Response to 'Percentages in Cross-tabs that do not round correctly'

  1. lbass - October 29th, 2006 at 2:42 pm

    Ken,

    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:

    totext(,2)+”%”

    I have recommended this method for this very reason.

    -LB


Leave a Reply

Jeff-Net
Recrystallize Pro

Crystal Reports Server