Calculated field for running balance

[focus54]

I'm looking for a way to add a calculated balance column on each row that contains a running balance by taking the balance value from the previous row and adding/subtracting values from current row to arrive at a new balance.

result set includes "increase" and "decrease" columns:

Increase ----- Decrease ------- Balance (calculated)

100 --------------------------- 100

400 --------------------------- 500

---------------- 200 ---------- 300

-200 --------------------------100

--------------- -300 ---------- 400

These values will be currency with 2 decimals but I think we can ignore that for now.

[ShWolf]

Hi,

Unfortunately, this is not possible when using a calculated field. You should write custom JS.

[fozz2k]

Are there any newbie friendly resources that might be able to help me with something like this.

 

I'm trying to create an app that logs points, gives users the ability to redeem points and keeps a running balance based on both.

 

I have looked at JS and appears daunting.....

 

Thanks in advance.

[Jan]

Hello fozz2k,

 

Can you say a bit more about your goal?

What the data is stored in the table?

Do you want only to display Balance or save it too?

[JolliBeng]

Hi,

You can try to do calculate the running balance using Triggered Actions. I have done this on my app and here are the screenshots of the sample table and triggered action.

I hope this helps.

 

-JolliBeng

[cheonsa]

Hi all!

You can also use Calculated field in the Reports DataPage to display the running balance: 

(SELECT SUM(ISNULL([@field:Increase],0) - ISNULL([@field:Decrease],0)) FROM Running_Balance WHERE Code= target.[@field:Code] AND ID <= target.[@field:ID])

You may check this for reference:

https://c0acp706.caspio.com/dp/2d9860007b629b8a4b074df5af34

[NailDyanC]

Hello, just want to add what I have found. This is Caspio howto article about running total that might help: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/calculate-a-running-total-in-your-report/