Re: sqlplus - compute sum of (colA - colB) on report

From: Ed prochak <ed.prochak_at_alltel.com>
Date: 21 Mar 2002 09:43:24 -0800
Message-ID: <e51b160.0203210943.77041f69_at_posting.google.com>


My suggested changes are in lower case:

Richard Booker <rbooker_at_21stcentury.net> wrote in message news:<3C99CEB6.2820EF5F_at_21stcentury.net>...
> 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
 compute sum of difference on report
> SET PAGESIZE 60
> SET LINESIZE 150
> SET NEWPAGE 2
> SELECT
> DEL_AGENCY,
> SITE_NAME,
> AMT_BEFOREACCESS - ACCESS_FEE
 (AMT_BEFOREACCESS - ACCESS_FEE) as difference
> 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.

next time, please give a description of the problem. Don't forget to mention what version of ORACLE you are using.

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com
Received on Thu Mar 21 2002 - 18:43:24 CET

Original text of this message