Create Formula referring to a Summarized Cell

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.

Thanks
Mike

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

Thank you for this. I will try it.