Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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