Column Sum in a Grid

Question

Hi,

Can someone please provide a small & clear example of code snippet on how to find total for column values in a grid ?
I am new to Appian and finding difficult in understanding the related blogs & docs.

Usecase: I have two columns. Rows appear upon clicking Add Dynamic link. last row of the grid should have Total/Sum of respective columns row data

Mike Schmitt · Answer

In an editable grid luckily it's pretty easy to simply declare an extra row below the dynamically-generated rows, containing the same number of columns as the above rows (please note also that every row will need the same number of columns, i'm unclear if your use case fits this). Then in that final row you simply make all cells read-only values (either a text field with readOnly set to true, or rich text display fields), and declare your calculated column totals. You can either do this in the value declaration itself, or in a local variable that's calculated in advance (the latter would make it easier to persist the calculated totals to a different variable for the purposes of saving, if you need this).

Mike Schmitt · Answer

matteos7659 said: row with the total of my columns at the end of read-only grid 
 That's a much harder question, as the original question here involved an editable grid. Generally it might be easiest to take the above approach (using an editable grid still) and just making all fields read-only.

Mike Schmitt · Answer

Can you clarify - are you intending to make a separate column for each row of data in local!gridQuestionsList? That seems counter intuitive to the way an editable grid would normally work.