Skip to main content
September 16, 2021
Question

Column Sum in a Grid

  • September 16, 2021
  • 8 replies
  • 1 view

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

8 replies

mikes0011
Brainy
September 16, 2021

Do you have any example code for what you've tried so far?

The Expression Guru
September 16, 2021

Thank you Mike for the response. Here is my code 
[View:/cfs-file/__key/communityserver-discussions-components-files/13/gridtest.txt:64:59]

I have tried this. But not able see Total label at all.
Also not sure how can I sum up values.

mikes0011
Brainy
September 16, 2021

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.

The Expression Guru
abhayd3663
March 6, 2023

You can have the textField just below the grid to display the total, it would be easier.