Create Formula referring to a Summarized Cell

1

I’m trying to create a Daily Cash Flow. I need to create a daily balance based on the previous days balance added to current day’s balance. Any ideas please.

image
image557×830 36.7 KB

Thanks
Mike

2

Hi @Michael_Brits to get the past balance, use this formula:

thisTable.Filter(Date<thisRow.Date).Sort(false,Date).Balance.First()

Then you can add the current balance to it in another column (or this one) to get the current.

1 Like
3

Thank you for this. I will try it.