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] Row count with aggrigation function

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Row count with aggrigation function
 Login/Join
 
User1
Silver Member
posted
Hi All,

In the below code, I need to display the total count at the end.

Can anyone please suggest..!!


ENGINE DB2 SET DEFAULT_CONNECTION CNAME
-SET ECHO = ALL;
-DEFAULT &FROM_DATE='2015/07/21'
-DEFAULT &TO_DATE='2015/08/21'

SET ASNAMES = ON
SQL DB2 EX SYSPROC.TEST('&FROM_DATE','&TO_DATE')@
;
TABLE FILE SQLOUT
ON TABLE SUBHEAD
" STOP PAYMENT COUNT BY CHANNEL"
SUM CNT.STOP_PYMT_CHANNEL AS COUNT_STOP_PYMT
BY STOP_PYMT_CHANNEL
END

Thanks,
User1

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


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
Dave
Master
posted Hide Post
This should do the trick:

TABLE FILE SQLOUT
ON TABLE SUBHEAD
" STOP PAYMENT COUNT BY CHANNEL"
SUM CNT.STOP_PYMT_CHANNEL AS COUNT_STOP_PYMT

COMPUTE AGGR_COUNT/D12 = AGGR_COUNT + CNT.STOP_PYMT_CHANNEL;

BY STOP_PYMT_CHANNEL
END


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
User1
Silver Member
posted Hide Post
Hi ,

Thanks for this

But I need to provide the sum of count at the footer side with single value.

For ex,
Total count= 100

Thanks ,
User1


WebFOCUS 8
Windows, All Outputs
 
Posts: 37 | Registered: September 05, 2015Report This Post
StuBouyer
Guru
posted Hide Post
COLUMN-TOTAL ?

I think you need to read some manual but more importantly talk to your management about some WebFOCUS training.

You obviously know what you want to do but are just missing the knowledge of where to look or what tools will allow you to get things done.

Including Totals and Subtotals

or possibly Summing and Counting Values from Manipulating Display Fields with Prefix Operators

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


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Hi User1,
Take a page out of Stu's book: training is paramount. Also you will learn that WebFOCUS can provide many possible different solutions.
Here is one based upon Dave's:
  
TABLE FILE CAR
ON TABLE SUBHEAD 
"SEATS COUNT"
SUM CNT.SEATS
COMPUTE TOTCNTSEATS/I5=LAST TOTCNTSEATS + CNT.SEATS; NOPRINT
BY SEATS
ON TABLE SUBFOOT
"TOTAL SEATS COUNT=<TOTCNTSEATS "
END


And here is another:
  
TABLE FILE CAR
SUM CNT.SEATS
BY SEATS
ON TABLE RECAP
TOTCNTSEATS/I5=C1;
ON TABLE SUBHEAD 
"SEATS COUNT"
ON TABLE SUBFOOT
"TOTAL SEATS COUNT=<TOTCNTSEATS"
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] Row count with aggrigation function

Copyright © 1996-2020 Information Builders