OK there, I'm having a bit of brain freeze here.

So, how do I display the total dealer_cost and retail_cost and the average of the, totally bogus, sales in the sale line (subfoot, subtotal, recompute, whatever) for this report? The average sales should be 19052.

SET PAGE = NOLEAD
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST 
COMPUTE SALES/D12C=RCOST * 1.1 ; 
BY COUNTRY BY CAR
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS CARFILE
END
TABLE FILE CARFILE
SUM DEALER_COST SALES RETAIL_COST BY COUNTRY BY CAR
ON TABLE SUBFOOT
"AVERAGE SALES: <ST.AVE.SALES"
ON TABLE SUBTOTAL
END

Thanks in Advance, Doug

PS: This is in 8105.

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

Doug,

Thaw:

  
-* File doug02.fex
SET PAGE = NOLEAD
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST 
COMPUTE SALES/D12C=RCOST * 1.1 ; 
BY COUNTRY BY CAR
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SET ASNAMES ON
ON TABLE HOLD AS CARFILE
END
TABLE FILE CARFILE
SUM DEALER_COST RETAIL_COST SALES  
BY COUNTRY BY CAR
ON TABLE SUBTOTAL DEALER_COST RETAIL_COST AVE. SALES
END

That's a mazing Danny,

What's with the space between "AVE." and "SALES"? It works with that spaced out! Yea!

BTW: I need this to work with a lengthy / left justified heading and table footing for HTML, PDF, and Excel AND breaking on, in this case, COUNTRY. I'm working with that now to see if it works.

Thanks, Doug

quote:

AVE. SALES

Check out this link for more information on the space after AVE. field - Usage Notes for Summary Prefix Operators


Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders