How to get field value from above row in joget spreadsheet to make calculation in current row?

 
1
0
-1

Hi Folks

In Joget spreadsheet, I am unable to reference previous row data in current row.

I want to make calculation based on balance of previous row .

How to get field value from above row in joget spreadsheet to make calculation in current row?

Balance = Balance(Previous Row)+ Received-Paid

Is that possible to do so?


Thanks

Nyi Nyi Lin


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, I believe the spreadsheet element is using the handsontable library so for advanced calculations perhaps you could try to refer to the handsontable docs https://handsontable.com/docs/6.2.2/demo-summary-calculations.html

        CommentAdd your comment...