RE: Sum of Previous Record
Thanks All , I solved the problem as follows : I defined a sum summary column on same group with the reset on group above it,the to add balance brought forward i used the first summary function to add balance brought forward to the first record. Bay . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sum of Previous Record
Depending on the structure of your table, you can also use plain SQL with a self-join, similar to: select v1.cust_id , v1.order_date , v1.order_total , sum(v2.order_total) cumulative_total from orders v1 , orders v2 where v1.cust_id = v2.cust_id AND v2.order_date <= v1.order_date group by v1.cust_id, v1.order_date, v1.order_total ; Cheers, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, June 04, 2003 8:05 AM To: Multiple recipients of list ORACLE-L Walid You can use SUM as an analytic function like this: - SQL> select credit, debit, sum(credit + debit) over (order by rowid) from foo; CREDIT DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID) -- -- --- 3 0 3 0 -1 2 1 0 3 Obviously, you will need to order by something more sensible than the rowid (perhaps a timestamp). > -Original Message- > From: Walid Alkaakati [mailto:[EMAIL PROTECTED] > Sent: 04 June 2003 14:10 > To: Multiple recipients of list ORACLE-L > Subject: Sum of Previous Record > > > > > Hi list , > > Can you help me please . > > I have a report that show data as follows : > > debit credit balance > 30-3 > 0 -1 2 > 1 0 3 > > Is their a way to get balance without using a separet query in a > formula column,i .e i need the value of the previous > record in the same repeating frame. > > Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Walid Alkaakati > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sum of Previous Record
How about SELECT DEBIT,CREDIT,CREDIT-DEBIT FROM WHATEVER_THE_TABLE WHERE CREDIT*CREDIT=-1; Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 04, 2003 9:10 AM To: Multiple recipients of list ORACLE-L Hi list , Can you help me please . I have a report that show data as follows : debit credit balance 30-3 0 -1 2 1 0 3 Is their a way to get balance without using a separet query in a formula column,i .e i need the value of the previous record in the same repeating frame. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sum of Previous Record
Hi , Iam looking on how to solve this in a report ,,, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid Alkaakati INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sum of Previous Record
Walid You can use SUM as an analytic function like this: - SQL> select credit, debit, sum(credit + debit) over (order by rowid) from foo; CREDIT DEBIT SUM(CREDIT+DEBIT)OVER(ORDERBYROWID) -- -- --- 3 0 3 0 -1 2 1 0 3 Obviously, you will need to order by something more sensible than the rowid (perhaps a timestamp). > -Original Message- > From: Walid Alkaakati [mailto:[EMAIL PROTECTED] > Sent: 04 June 2003 14:10 > To: Multiple recipients of list ORACLE-L > Subject: Sum of Previous Record > > > > > Hi list , > > Can you help me please . > > I have a report that show data as follows : > > debit credit balance > 30-3 > 0 -1 2 > 1 0 3 > > Is their a way to get balance without using a separet query in a > formula column,i .e i need the value of the previous > record in the same repeating frame. > > Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Walid Alkaakati > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sum of Previous Record
Have a look at analytical functions (LAG() and the like) >- --- Original Message --- - >From: "Walid Alkaakati" ><[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 04 Jun 2003 05:10:14 > > > >Hi list , > >Can you help me please . > >I have a report that show data as follows : > >debit credit balance >30-3 > 0 -1 2 > 1 0 3 > >Is their a way to get balance without using a >separet query in a >formula column,i .e i need the value of the >previous >record in the same repeating frame. > >Thanks > > >-- >Please see the official ORACLE-L FAQ: >http://www.orafaq.net >-- >Author: Walid Alkaakati > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 >http://www.fatcity.com >San Diego, California-- Mailing list and >web hosting services >To REMOVE yourself from this mailing list, send an >E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of >'ListGuru') and in >the message BODY, include a line containing: UNSUB >ORACLE-L >(or the name of mailing list you want to be removed >from). You may >also send the HELP command for other information >(like subscribing). >--- >-- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).