Crosstab Total Calculation

[dukeslater]

Crystal XI crosstab issue:

2007 2008 2009 Total

Town 1: 3 5 8 16


Don't need the total, but I'd take it if needed. What I really need is a calculation on the total (divided by 10):

2007 2008 2009 Total Target

Town 1: 3 5 8 16 1.6


I know there are crosstab gurus out there who know a simple solution to this. Thanks in advance.

 

[dukeslater]

Finally found the thread I was looking for - 149-1356319, and in this case the answer was even simpler - just put the following formula in the display string:

whileprintingrecords;
numbervar v_totalcount:= currentfieldvalue/10;
totext(v_totalcount,"#.#")

Retroactive thanks to lbass.