Referencing the cell above

[Johg_Ananda]

Hi @Michael_Brits check out my answer to this post:

Create Formula referring to a Summarized Cell

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.