[Solved]Accordian Summarize not displaying correctly
Hello:
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,
WebFocus 7.7.02 WinXP
October 18, 2010, 04:17 PM
Kerry
Thanks Joe for sharing the solution with all.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.