List Report

[admin_cog]

I have list report. How can I implement below
                       

        Name    Sal    Sal+comm
        A               1000           1200
        B              1200      1500
        C              1500           1800
        D              1800            2000

My requirement is B sal will be the A sal+comm and C sal will be B sal+comm.

   

[cschnu]

Will a running-total calculation work?

[admin_cog]

hi ,

i used running-total  and running-difference . but it does not work.
can you please provide me with syntax

thanks

[cschnu]

Name    Sal    Sal+comm
         A               1000           1200
         B              1200      1500
         C              1500           1800
         D              1800            2000

Do you have sample data, rather than desired output data?


Also, you might want to look into some SQL functions http://www.orafaq.com/node/55. Look for "LEAD and LAG".