TABLE FILE CAR
SUM
DEALER_COST
AVE.DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL AS '*TOTAL COUNTRY'
END

I am trying to display the avarage in the total column any ideas

Try:

TABLE FILE CAR
SUM
DEALER_COST
AVE.DEALER_COST
CNT.DEALER_COST NOPRINT
BY COUNTRY
BY CAR
ON TABLE RECAP
TOT_AVG_DC\D12.2=DEALER_COST / CNT.DEALER_COST;
ON TABLE SUBFOOT
"TOTAL END

I believe that will get you to the number you want... formatting is up to you!

Look for "Manipulating Summary Values With Prefix Operators" in the manual.

An example (that works???):

DEFINE FILE CAR
DC/D7 = DEALER_COST;
END
TABLE FILE CAR
SUM
DEALER_COST AS 'DEALER,COST'
AVE.DC      AS 'AVERAGE,DEALER,COST'
BY COUNTRY
BY CAR
ON COUNTRY RECOMPUTE SUM. DEALER_COST AVE. DC AS '*TOTAL COUNTRY'
END

you can also use prefixes in the sub-total:

 
SET SUMMARYLINES=NEW
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE SUBTOTAL
AVE. DEALER_COST
SUM. RETAIL_COST
END
 

Unfortunately, the example you cite from the manual is a simplistic one and will not work if the Average is done on a field which is also being summed, naming the field twice, once without a prefix operator and once with a prefix operator messes up the subtotal/summarize/recompute.

I think this works

TABLE FILE CAR
COUNT MODEL NOPRINT
BY COUNTRY
BY CAR
SUM
DEALER_COST
COMPUTE
AVCOST = C2 / C1;
BY COUNTRY
BY CAR
ON COUNTRY RECOMPUTE
END

right. I wasn't using the same column twice. if you need both the sum and the average of the same column, you can DEFINE/COMPUTE another field with a different name. (the SUM. is optional. If omitted, SUM is the default operation)

try using subfoot
and in the subfoot use:

quote:

subfoot

try using in the subfoot
double quote left caret ave.fieldname double quote

Ira