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>,

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

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

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,

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