Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]Accordian Summarize not displaying correctly
Go
New
Search
Notify
Tools
Reply
  
[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, 2006Reply With QuoteReport 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: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

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

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.