Multi Row Formula help

[agrawaluk]

This is probably way too easy, but I am not able to figure out the logical approach to this. 

I have two Columns: Date and Net Cashflows

I have to create two other columns: Opening Balance and Closing Balance

Opening Balance+Net Cashflow = Closing Balance

Opening balance and closing balance for minimum date should be 0 (this is something that needs to be implemented in the workflow)

Every opening balance = t-1 day's closing balance. 

Sample:

Date	Opening Balance	Net Cashflow	Closing Balance
3/16/2020	0	0	0
3/17/2020	0	8	8
3/18/2020	8	7	15
3/19/2020	15	6	21

[TomWelgemoed]

Hi @agrawaluk ,

You got so many responses! Let me know if they don't quite answer your question and I'll try to help out.

Regards,

Tom

[agrawaluk]

Hi @TomWelgemoed 

@AbhilashR and @Jonathan-Sherman replies answer my question. Thanks for all your help guys and sorry about the late reply.

Best,

Utkarsh

[psoma]

this is my first posting attempt.. i liked it.. thought it will be of help