As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.
I got everything to work correctly on my accordian report except for the summarize totals. Totals show up on expanded section (skills) instead of the first by which is EmpGroupName.
-* File skilltest.fex
ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX ORBIT.dbo.AHTSkill '&dte','&edte'
;
TABLE FILE SQLOUT
PRINT
EmpDivisionName
EmpGroupName
skill
calls
acdtime
acwtime
holdacdtime
WHERE skill EQ &skill.(OR(FIND SKILL IN &skill2)).select.;
ON TABLE HOLD AS DIVY
END
TABLE FILE DIVY
SUM
calls/I11C AS 'Calls Ans'
calls NOPRINT
acdtime NOPRINT
acwtime NOPRINT
holdacdtime NOPRINT
COMPUTE AHT/D8.2 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls;
COMPUTE AVGTalk/D8.2 = IF calls EQ 0 THEN 0 ELSE acdtime / calls;
AS 'AVG Talk'
COMPUTE AVGACW/D8.2 = IF calls EQ 0 THEN 0 ELSE acwtime / calls;
AS 'AVG ACW'
COMPUTE AVGHold/D8.2 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls;
AS 'AVG Hold'
BY EmpGroupName AS 'Group Name'
SUM
calls/I11C AS 'Calls Ans'
calls NOPRINT
acdtime NOPRINT
acwtime NOPRINT
holdacdtime NOPRINT
COMPUTE AHT/D8.2 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls;
COMPUTE AVGTalk/D8.2 = IF calls EQ 0 THEN 0 ELSE acdtime / calls;
AS 'AVG Talk'
COMPUTE AVGACW/D8.2 = IF calls EQ 0 THEN 0 ELSE acwtime / calls;
AS 'AVG ACW'
COMPUTE AVGHold/D8.2 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls;
AS 'AVG Hold'
BY EmpGroupName AS 'Group Name'
BY skill
HEADING
""
FOOTING
""
WHERE EmpDivisionName EQ '&DIV';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDABLE ON
ON TABLE SUMMARIZE DIVY.DIVY.calls DIVY.DIVY.calls DIVY.DIVY.acdtime DIVY.DIVY.acwtime DIVY.DIVY.holdacdtime AHT AVGTalk AVGACW AVGHold DIVY.DIVY.calls DIVY.DIVY.calls DIVY.DIVY.acdtime DIVY.DIVY.acwtime DIVY.DIVY.holdacdtime AHT AVGTalk AVGACW AVGHold AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
Thanks for any help possible!
----------------------------------- One of my new co-workers help correct this issue for me. The on table total needed to be under the first by field. Thanks!This message has been edited. Last edited by: JOE,