[CLOSED] "TABLE RECOMPUTE" problem with the empdata sample
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?
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 ENDThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8 Windows, All Outputs
May 22, 2017, 10:02 AM
BabakNYC
You can specify column names in TOTAL.
Something like this:
ON TABLE RECOMPUTE SUM. Fieldname1 AVE. Fieldname2 AS 'Total:'
WebFOCUS 8206, Unix, Windows
May 23, 2017, 08:19 AM
MartinY
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.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007