Calculating Values Across Rows?

[sjdig]

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.

[cognostechie]

There is a function called 'running-difference'. Try that.