# Creating a formula to maintain a running balance

**URL:** <https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973>\
**Category:** Ask for Help\
**Created:** [December 23, 2023, 11:53pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973 "2023-12-23T23:53:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [December 23, 2023, 11:53pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/1 "2023-12-23T23:53:02Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 24, 2023, 2:49am UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/2 "2023-12-24T02:49:39Z")

</div>

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

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

[https://www.loom.com/share/042be3be13004355b0dedec1be67b400](https://www.loom.com/share/042be3be13004355b0dedec1be67b400)

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [January 5, 2024, 2:41pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/3 "2024-01-05T14:41:59Z")

</div>

Can I run this query on Glide Big Table?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 5, 2024, 2:46pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/4 "2024-01-05T14:46:46Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [January 5, 2024, 3:02pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/5 "2024-01-05T15:02:55Z")

</div>

Thank a lot @Darren_Murphy 👍 🤝

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 5, 2024, 3:05pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/6 "2024-01-05T15:05:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Bungchow\_IDEApps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bungchow_ideapps/32/49062_2.png) [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)\
**Post date:** [January 5, 2024, 3:12pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/7 "2024-01-05T15:12:02Z")

</div>

OK, well noted.

---

<div class="post-metadata">

**Author:** ![Chan\_Mete](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chan_mete/32/45210_2.png) [@Chan\_Mete](https://community.glideapps.com/u/Chan_Mete)\
**Post date:** [July 7, 2024, 3:04pm UTC](https://community.glideapps.com/t/creating-a-formula-to-maintain-a-running-balance/68973/8 "2024-07-07T15:04:16Z")

</div>

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