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.
Have a look at the below. I’ve not tried that technique with Big Tables, but I think it should work.
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)
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:
Your use case may not be as simple as that, but I’ll be surprised if you can’t get it to work.
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 
