cumulative sum

[doespirito]

Hello,

For cash flow monitoring, I try to calculate a cumulative sum by adding an initial balance.

Can you help me realize that?

Here is a screenshot with the formula on excel tab.

I want to create the cumulative sum first. Then I will add the initial balance to this formula.

I enclose the qw file.

Thank you very much,

Arnault

[sunny_talwar]

Where do we get the starting cash number from? This is needed in addition to the total or the total can replace the starting cash row?

[doespirito]

two possibilities :

- add it in the formula (xxxxx + 700)

- put it in a variable

starting cash is needed in addition to the total and it gives final cash

final cash = starting cash + all movements i load in the application

Arnault

[doespirito]

i've finally used this expression

RangeSum(Above(TOTAL Sum(MontantK), 0, RowNo(TOTAL))) + 700

and it works fine,

even if I can not create a horizontal array...

Arnault