Focal Point Banner


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.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Accordian Summarize not displaying correctly

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved]Accordian Summarize not displaying correctly
 Login/Join
 
Platinum Member
posted
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
 
Posts: 236 | Registered: May 12, 2006Report This Post
Expert
posted Hide Post
Thanks Joe for sharing the solution with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Accordian Summarize not displaying correctly

Copyright © 1996-2020 Information Builders