I want to do some calculations on column total values and want to show calculated result values in Subfoot. The report example is:

Monthly Sales
Model	Sales	QTY
AAA	325000	16
BBB	548000	24
CCC	274000	8

I am able to print ST.SALES and ST.QTY in subfoot. But how to show further calculation on these totals i.e. Average Sale per Qty = (Total of Sales) / (Total of Qty)

This message has been edited. Last edited by: Abhi,

Something like this perhaps:

DEFINE FILE CAR
DOLLARS/D10 = RETAIL_COST * SALES;
SALES1/D10 = SALES;
END
-RUN

TABLE FILE CAR
SUM
COMPUTE AVG_SQ/D10 = TOT.DOLLARS / TOT.SALES1; NOPRINT
SALES1
DOLLARS
BY COUNTRY
ON TABLE SUBFOOT
"TOTAL<ST.SALES1<ST.DOLLARS"
"AVE SALES/QTY<AVG_SQ"

ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
FONT='ARIAL', SIZE=8, $
TYPE=TABFOOTING, HEADALIGN=BODY, JUSTIFY=RIGHT, $
TYPE=TABFOOTING, ITEM=1, JUSTIFY=LEFT, $
END
-RUN

Francis,

I appreciate your help with the code example. Now I am able to do lots of other calculations.

Thanks!