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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] TOTAL ON SUBFOOT FOR THE SECOND BY FIELD

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] TOTAL ON SUBFOOT FOR THE SECOND BY FIELD
 Login/Join
 
WFDevConsultant
Platinum Member
posted
Hi,

I am trying to show the total for each BY field but I am not able to get it to work for the second BY field. See my code below.

TABLE FILE CAR
SUM
COMPUTE DCOST/D12.2=DEALER_COST; NOPRINT
BY COUNTRY
PRINT
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
"ON CAR SUBFOOT
"END
-EXIT

I need to see the total by country and total by car.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


8.2.06
Windows, All Formats
 
Posts: 184 | Registered: December 27, 2013Report This Post
RSquared
Guru
posted Hide Post
Try this

/*
DEFINE FILE CAR
DCOST/D12.2=DEALER_COST;
END
TABLE FILE CAR

PRINT
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBFOOT
" TOTAL FOR ON CAR SUBFOOT
"TOTAL FOR
END
-EXIT

/*


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
WFDevConsultant
Platinum Member
posted Hide Post
That didn't work.


8.2.06
Windows, All Formats
 
Posts: 184 | Registered: December 27, 2013Report This Post
Francis Mariani
Expert
posted Hide Post
Please put your code within 
[code]
[/code]
tags - your SUBFOOT content disappears because of the left caret.

Dare I ask why you're using SUBFOOT to display totals?

Have you looked into the ST. prefix?

quote:
ST. - Produces a subtotal value of the specified field at a sort break in the report. This operator only applies when used in subheadings and subfootings.


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, 2005Report This Post
RSquared
Guru
posted Hide Post
quote:
DEFINE FILE CAR
DCOST/D12.2=DEALER_COST;
END
TABLE FILE CAR

PRINT
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBTOTAL
ON CAR SUBTOTAL MULTILINE
END
-EXIT


You can also leave out the multiline. I don't like to subtotal when there is only 1 line.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Report This Post
WFDevConsultant
Platinum Member
posted Hide Post
Actually I need to show the total on the subhead.


8.2.06
Windows, All Formats
 
Posts: 184 | Registered: December 27, 2013Report This Post
Danny-SRL
Virtuoso
posted Hide Post
WFDevCons,

If you need the totals above you can use:
  
-* File wfdevcon01.fex
SET SUBTOTALS = ABOVE
TABLE FILE CAR
PRINT
DEALER_COST
BY COUNTRY
BY CAR
ON CAR SUB-TOTAL
END

If you need the subtotals in the SUBHEAD you can use:
  
DEFINE FILE CAR
CODCOST/D6=DEALER_COST;
CADCOST/D6=DEALER_COST;
END
TABLE FILE CAR
SUM CODCOST NOPRINT
BY COUNTRY
SUM CADCOST NOPRINT
BY COUNTRY BY CAR
PRINT
DEALER_COST
BY COUNTRY
BY CAR
ON COUNTRY SUBHEAD
"<COUNTRY <CODCOST"
ON CAR SUBHEAD
" <CAR<CADCOST"
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=BODY, $
ENDSTYLE
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report 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     [CLOSED] TOTAL ON SUBFOOT FOR THE SECOND BY FIELD

Copyright © 1996-2020 Information Builders