AnsweredAssumed Answered

Calculated Balance (number) field in portal, that uses field result from the previous row

Question asked by lukasb on Apr 30, 2015
Latest reply on May 4, 2015 by lukasb

Title

Calculated Balance (number) field in portal, that uses field result from the previous row

Post

Hi all,

I have a portal (sorted by date) that has an ::credit field and an ::debit field. 

I would also like to add a ::Balance field in each row.

This should get the remaining ::balance of the previous row, add to it the ::credit and subtract the ::debit in order to have an updated balance in each row. 

It sounds simple but I cannot make the Balance field work. Should this be a script or a calculated value? Any tip please would be very appreciated. 

Thank you in advance,

Lukas

 

Outcomes