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] SUBTOTAL ON ROW-WISE
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] SUBTOTAL ON ROW-WISE
 Login/Join
 
<msam>
posted
Hi,
I'm trying to get the SUBTOTAL for the following..
  ONE TWO THREE FOUR
       --------------------

A       10   10   10   10
B        5    5    5    5
C        3    3    3    3

SUBTOTAL 8    8    8    8


I need the SUBTOTAL ON B AND C
Please note that I'm not using the FOR field and I can't use RECAP .. any ideas would be appreciated...

Regards,
MSAM

This message has been edited. Last edited by: Kerry,
 
Reply With QuoteReport This Post
Expert
posted Hide Post
Could you use another sort field, and SUBTOTAL with WHEN.

DEFINE FILE CAR
 S_GROUP/A1 = IF SEATS EQ 2 THEN 'A' ELSE 'B' ;
END
TABLE FILE CAR
SUM SALES
BY S_GROUP
BY SEATS

ON S_GROUP SUB-TOTAL
WHEN S_GROUP EQ 'B'
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6275 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
<msam>
posted
Waz,
Is there a way to supress the TOTAL that we see at the end..?

Regards,
MSAM
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
ON TABLE NOTOTAL


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
<msam>
posted
THANKS GAMP...
IS THERE A WAY TO RENAME THE 'SUBTOTALB' AND NAME AS ONLY 'SUBTOTAL'..

Regards,
MSAM
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
No! The value of the BY field is always included right after the SUBTOTAL label. If you don't want to have it there then you'll need to use a SUBFOOT to make up your totals instead of SUBTOTAL.

It is also a good idea to set some time aside to learn the language. A look at "Creating Reports with WebFOCUS Language" manual would be of great help. Check it out in the Documentation section at IBI's Technical Support website.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
How about this:

DEFINE FILE CAR
 S_GROUP/A10 = IF SEATS EQ 2 THEN ' ' ELSE 'SUBTOTAL' ;
END
TABLE FILE CAR
SUM SALES
BY S_GROUP NOPRINT
BY SEATS

ON S_GROUP SUB-TOTAL AS ''
WHEN S_GROUP EQ 'SUBTOTAL'
END


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
<msam>
posted
FRANCIS,
WE DO NOT TO SUBTOTAL VALUES THAT HAVE 2 AS S_GROUP..

REGARDS,
MSAM
 
Reply With QuoteReport This Post
Expert
posted Hide Post
NEITHER DOES MY EXAMPLE.

Have you tried running the code?

This code:

DEFINE FILE CAR
 S_GROUP/A10 = IF SEATS EQ 2 THEN ' ' ELSE 'SUBTOTAL' ;
END
TABLE FILE CAR
SUM SALES
BY S_GROUP NOPRINT
BY SEATS

ON S_GROUP SUB-TOTAL AS ''
WHEN S_GROUP EQ 'SUBTOTAL'

ON TABLE NOTOTAL
END
Gives this result:

 SEATS   SALES
 -----   -----
     2   25400
 
     4   91730
     5   91290
 
  SUBTOTAL
        183020


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
<msam>
posted
THAT WORKS FRANCIS.... THANKS A LOT.. I REALLY APPRECIATE YOUR HELP...


REGARDS,
MSAM
 
Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
NEITHER DOES MY EXAMPLE


Francis, I like your subtle way to send some messages across Wink

MSAM, this may be off topic but it's always a good thing to keep in mind when making use of forums: Netiquette.

quote:

Avoid writing e-mail or posting messages in blogs, newsgroups, forums, chat rooms and other online venues using all capital letters. IT LOOKS LIKE YOU'RE SHOUTING! Not only that, it's difficult to read.

This message has been edited. Last edited by: njsden,



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Great response Francis. Good One

Thats the code, by the way.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6275 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] SUBTOTAL ON ROW-WISE

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