Dear Comunity

I have a strange problem concerning the "TABLE RECOMPUTE" statement in the following report.
What I expect from WF is that on the "Total" row WF also calculates the averages for the column "AVE1" and "DISPDATE". But nothing shows up there. Is this a bug or do I something wrong?

Any help is appreciated.

Thanks for your help and time.

Best regards
Matt



DEFINE FUNCTION SEC_TIME/A20 (DIFF_SEC/D12.2)
SEC_PER_HR/I5= 60 * 60;
SEC_PER_DAY/I5= SEC_PER_HR * 24;
DAYS/I3= IF DIFF_SEC LT SEC_PER_DAY THEN 0 ELSE DIFF_SEC/SEC_PER_DAY ;
-*GET THE DIFF IN WHOLE HOURS
HOURS/I2=( DIFF_SEC - (DAYS * SEC_PER_DAY)) / SEC_PER_HR;
MINT/I2= ( DIFF_SEC - (DAYS * SEC_PER_DAY) - (HOURS * SEC_PER_HR))/60 ;
SEC/I2 = DIFF_SEC - (DAYS * SEC_PER_DAY) - (HOURS * SEC_PER_HR) - MINT * 60;

DISP_TIME/A8= EDIT(HOURS)|':'|EDIT(MINT)|'.'|EDIT(SEC);
SEC_TIME/A20 = FTOA(DAYS,'(F3)','A3') | ' ' | 'Days ' | DISP_TIME;
END

DEFINE FILE ibisamp/empdata
-* CREATING DATE TIME FIELDS FOR TEST (NEXT FOUR LINES)
TIME1/A20= IF DEPT EQ 'ACCOUNTING' THEN '2005/12/20 12:30:05' ELSE
IF DEPT EQ 'SALES' THEN '2005/01/01 09:25:27' ELSE
IF DEPT EQ 'MARKETING' THEN '2005/10/03 09:25:27' ELSE
'2005/02/02 10:15:00'; TIME2/A20= IF DEPT EQ 'ACCOUNTING' THEN '2005/12/21 20:23:04' ELSE
IF DEPT EQ 'SALES' THEN '2005/01/04 10:25:37' ELSE
IF DEPT EQ 'MARKETING' THEN '2005/10/07 11:25:27' ELSE
'2005/02/09 18:15:03';
DATE_TIME1/HYYMDSA= HINPUT(20,TIME1,10,'HYYMDS');
DATE_TIME2/HYYMDSA= HINPUT(20,TIME2,10,'HYYMDS');
DIFF_SEC/D12.2= HDIFF(DATE_TIME2, DATE_TIME1, 'SECOND', 'D12.2');
DISPDATE/A20 = SEC_TIME(DIFF_SEC);
END

TABLE FILE IBISAMP/EMPDATA
SUM
COMPUTE A/D12.2=TOT.DIFF_SEC;
COMPUTE B/D12.2=CNT.DIFF_SEC;
COMPUTE C/D12.2=TOT.DIFF_SEC/CNT.DIFF_SEC;
AVE.EMPDATA.EMPDATA.DIFF_SEC
COMPUTE AVE1/A20 = SEC_TIME(C);
BY EMPDATA.EMPDATA.DEPT
PRINT
EMPDATA.EMPDATA.DISPDATE
BY EMPDATA.EMPDATA.DEPT
BY EMPDATA.EMPDATA.LASTNAME
ON TABLE RECOMPUTE
ON TABLE SET HTMLCSS ON
END

This message has been edited. Last edited by: FP Mod Chuck,

You can specify column names in TOTAL.

Something like this:

ON TABLE RECOMPUTE SUM. Fieldname1 AVE. Fieldname2 AS 'Total:'

samatthias,

Your function return an alpha string (A20).
An average cannot be performed on an alpha.

Same reason for DISPDATE.

Focus needs number to perform an average.