Calculated Balance (number) field in portal, that uses field result from the previous row
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,