I'm using 7.6.4

I have a query that I need to display the total number of records in the SUBFOOT, as well as the average of one of the columns in the SUBFOOT.

The total portion works, but the average portion does not.

Any help would be appreciated.

DEFINE FILE SOC_CLR
RECCOUNTER/I8 = 1;
CYCLE_DAYS/I8= IF INVESTIGATION_OPEN EQ '' THEN 0 ELSE DATEDIF(INVEST_OPEN2, INVEST_CLSD2, 'D');
END

TABLE FILE SOC_CLR
PRINT
REQUESTER_LOGIN_NAME_ AS 'Employee ID'
CYCLE_DAYS AS 'Cycle Days'

ON TABLE SUBFOOT
"Total Records = "Average Cycle Time =
WHERE RECORDLIMIT EQ 10;

ON TABLE PCHOLD FORMAT EXL2K
END

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

Here's a simple example that might help:

DEFINE FILE CAR
MODELCNT/I3 = 1;
END

TABLE FILE CAR
SUM
DEALER_COST
MODELCNT NOPRINT
BY CAR
BY MODEL

ON TABLE SUBTOTAL

ON TABLE RECAP
COST_AVG/D11.2 = DEALER_COST / MODELCNT;

ON TABLE SUBFOOT
"Total Cars: <TOT.MODELCNT"
"Average Dealer Cost: <COST_AVG"

END

Sean

Is there any way to make it work with a TABLE FILE PRINT rather than a TABLE FILE SUM?

Try it.