I am trying to write a report where I subtotal all my columns but one. On that column I want to have an average. My code for that looks like this:

ON DUMMY SUMMARIZE
SHIP_QTY
ORD_QTY
EXT_PRICE AS 'TOTAL'
ON DUMMY SUMMARIZE
AVE. FQY AS 'TOTAL'

When I run it I am getting the following error

" (FOC36376) CANNOT COMBINE SUBTOTAL/RECOMPUTE STYLES WHEN SUMMARYLINES=OLD
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND"

Does anyone know what that error means?

From what I am reading here

http://www.informationbuilders.com/new/tfc/summer2004/03_subtotal.html

I should be able to do this. Does anyone have any suggestions?

Eric

You want to issue:

SET SUMMARYLINES=NEW

If you read the doc, you see that the SUMMARYLINES OLD does not let you mix AVE with SUM on the subtotal. SUMMARYLINES=OLD is also the default.

Thanks I must have missed that line in the doc.