🚀 go-pugleaf

Thanks a lot.

David Bechtel wrote:

> Easy enough.  What you need to do is name the calculation when it is
> selected and then compute the sum on that name.
>
> Like:
> .
> .
> COMPUTE SUM OF DAVE ON REPORT
> .
> .
> SELECT
> DEL_AGENCY,
> SITE_NAME,
> (AMT_BEFOREACCESS - ACCESS_FEE) AS DAVE
> FROM BILLINGS_HEADER
>
> I think that you will find this as an example in the Oracle for Beginners
> book.
>
> Good Luck,
> Dave Bechtel
>
> Richard Booker wrote:
>
> > First and foremost, thanks to all of you for providing and contributing
> > to such a useful resource as this newsgroup.
> >
> > I am trying to include on a report a grand total of the results of
> > subtracting one column's value from another.
> >
> > Below is my best effort.  Any help will be greatly appreciated.
> >
> > SPOOL M:\CCMIS\SQL\REPORT_OF_SUBMITTED_BILLINGS.TXT
> > TTITLE 'LIST OF SUBMITTED BILLINGS'
> > BREAK ON DEL_AGENCY ON REPORT SKIP 2
> > COMPUTE SUM OF (AMT_BEFOREACCESS - ACCESS_FEE) ON REPORT
> > SET PAGESIZE 60
> > SET LINESIZE 150
> > SET NEWPAGE 2
> > SELECT
> > DEL_AGENCY,
> > SITE_NAME,
> > AMT_BEFOREACCESS - ACCESS_FEE
> > FROM BILLINGS_HEADER
> > WHERE MONTH = '02' AND YEAR = '2002' AND SUBMIT_FLAG = 'Y'
> > ORDER BY DEL_AGENCY;
> > CLEAR COLUMNS
> > CLEAR BREAKS
> > CLEAR COMPUTES
> > TTITLE OFF
> > SPOOL OFF
> >
> > Thanks again.