Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: admin_cog on 18 Jun 2009 07:47:39 AM

Title: List Report
Post by: admin_cog on 18 Jun 2009 07:47:39 AM
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.

   
Title: Re: List Report
Post by: cschnu on 18 Jun 2009 02:14:54 PM
Will a running-total calculation work?
Title: Re: List Report
Post by: admin_cog on 19 Jun 2009 12:32:19 AM
hi ,

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

thanks
Title: Re: List Report
Post by: cschnu on 19 Jun 2009 09:58:01 AM
QuoteName    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".
Text only | Text with Images