Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sjdig on 29 Oct 2018 02:07:57 PM

Title: Calculating Values Across Rows?
Post by: sjdig on 29 Oct 2018 02:07:57 PM
I was wondering if there was potentially a way to calculate a value across rows when multiple values can be present.

I would like to find when a value becomes negative for a value.

To demonstrate via example:

Balance (Start of Yesterday)                                          Debit (Yesterday)       Balance (After Debit)
$80.00                                                                         $13.00                      $67.00
$67.00 (update from Balance (After Debit Row)               $50.00                      $17.00
$17.00 (update from Balance (After Debit Row)               $40.00                      -$23.00

I would like to calculate the balance as it declines from the debits and the updated values at the right.

Is this possible? I'm guessing it may involve one of the running functions.

Thanks in advance for any assistance you can provide.


Title: Re: Calculating Values Across Rows?
Post by: cognostechie on 29 Oct 2018 02:37:16 PM
There is a function called 'running-difference'. Try that.
Text only | Text with Images