8 Replies Latest reply on May 4, 2015 12:31 AM by lukasb

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

    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