Creating a formula to maintain a running balance

This running balance has a beginning balance with additions and deductions, but the running balance should use the previous row’s balance and then move forward with the new balance. The system adds back the previous row’s balance to the new one. I hope this makes sense. New at learning this.

Thanks.

The query column can help you with this. The video below walks through setting it up.

https://www.loom.com/share/042be3be13004355b0dedec1be67b400

6 Likes

Can I run this query on Glide Big Table?

Good question.

I’d say that the answer is yes, so long as the rollup through the query is targeting a non-computed column.

In my video, the rollup is targeting a computed column, so that wouldn’t be supported with Big Tables.

2 Likes

Thank a lot @Darren_Murphy :+1: :handshake:

Actually, the other thing is the technique for creating the Row Index isn’t possible with Big Tables, so the row numbers would also need to be in non-computed columns. That would probably make it impractical.

OK, well noted.

@Darren_Murphy I’ve tried it, the solution per the video works great, thank you.