Print Page - Calculate difference within one column

Title: Calculate difference within one column
Post by: Koda7 on 31 May 2013 05:05:56 PM

I have a basic list query set up (in black):

Week # Amount WTW Chg
1 234 0
2 343 109
3 422 79
4 489 67
5 589 100

As the weeks go forward, the amount will always grow. I want to put another column in to calculate the week to week change that should look like the 3rd column in Red.

Title: Re: Calculate difference within one column
Post by: blom0344 on 01 Jun 2013 02:15:24 PM

I think that you may find the 'running-difference' function appropriate..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Koda7 on 31 May 2013 05:05:56 PM