# Big Tables - Running Balance **URL:** \ **Category:** Ask for Help\ **Tags:** big-tables\ **Created:** [October 28, 2024, 8:25pm UTC](https://community.glideapps.com/t/big-tables-running-balance/77427 "2024-10-28T20:25:46Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Scotttiey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotttiey/32/57378_2.png) [@Scotttiey](https://community.glideapps.com/u/Scotttiey)\ **Post date:** [October 28, 2024, 8:25pm UTC](https://community.glideapps.com/t/big-tables-running-balance/77427/1 "2024-10-28T20:25:46Z")
Hi, I know this has been mentioned previously but just wondering if anyone has found a solution/workaround for calculating running balances when using Big Tables. The scenario is an Interest Payments Table (linked to a Loan Table) where the Interest is calculated monthly. ![Screenshot 2024-10-28 at 14.25.59](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c047676ec16a61c6ec00fe0c5109e34d2d9c69dd.png) ---
**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:** [October 29, 2024, 3:00am UTC](https://community.glideapps.com/t/big-tables-running-balance/77427/2 "2024-10-29T03:00:56Z")
Have a look at the below. I’ve not tried that technique with Big Tables, but I think it should work. https://www.loom.com/embed/042be3be13004355b0dedec1be67b400 [https://www.loom.com/share/042be3be13004355b0dedec1be67b400](https://www.loom.com/share/042be3be13004355b0dedec1be67b400) ---
**Author:** ![Scotttiey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotttiey/32/57378_2.png) [@Scotttiey](https://community.glideapps.com/u/Scotttiey)\ **Post date:** [October 29, 2024, 8:06am UTC](https://community.glideapps.com/t/big-tables-running-balance/77427/3 "2024-10-29T08:06:42Z")
Unfortunately it doesn’t. This is what i was working with initially in the hope it would work but the filter on the Query does not show the RowIndex column (Find Element Index) ---
**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:** [October 29, 2024, 8:11am UTC](https://community.glideapps.com/t/big-tables-running-balance/77427/4 "2024-10-29T08:11:13Z")
hmm, do you actually need that though? I’m thinking that you could use the Date as a filter in the Query? Update: @Scotttiey I just did a simple test, and it works fine: ![CleanShot 2024-10-29 at 16.27.03@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/284f6288de7333ee422fe79751ca20f6d98a2257.png) Your use case may not be as simple as that, but I’ll be surprised if you can’t get it to work. ---
**Author:** ![Scotttiey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotttiey/32/57378_2.png) [@Scotttiey](https://community.glideapps.com/u/Scotttiey)\ **Post date:** [October 29, 2024, 8:51am UTC](https://community.glideapps.com/t/big-tables-running-balance/77427/5 "2024-10-29T08:51:44Z")
Hi @Darren_Murphy thank you i tried and it works and i was able to filter on the LoanID too as this table has payments from different Loans. I have quite a few computed columns (e.g. what you have as amount) which is the next issue as the Rollup doesnt like these. I might need to employ some actions that update the amount if any of the associated column values change. It still a bit clunky with BT hoping some of these limitations are overcome soon 🤞