Skip to main content
R
ravit0009
September 17, 2021
Question

How to add sum of values of the columns in a grid

  • September 17, 2021
  • 12 replies
  • 0 views

Hi, I could not find any docs satisfying my requirement .Can anyone help me in designing a grid as below.

Name textbox1 textbox2 textbox3
PersonA 10 1 100
PersonB 20 2 100
TOTAL 30 3 200

User will enter values in rows for textbox1, textbox2 and textbox3. Last row should display the total of the values entered in above rows. 

12 replies

stefanhelzle0001
stefanhelzle0001
Brainy
September 17, 2021

Following the patterns here

https://docs.appian.com/suite/help/21.3/Editable_Grid_Component.html#examples

You simply add a last row showing the required components and values.

    N
    niharikan2636
    June 7, 2024

    My requirement is i have to do sum of values returned when user applies filter in non -editable grid. For example, grid has mileage column, when user applies filter then if  rows are returned then i have to display sum of mileage returned from three rows.

    mikes0011
    mikes0011
    Brainy
    June 7, 2024

    This should be doable.  Generally speaking this is a use case where you should be querying the data in advance into a local variable, then using that to populate the grid.

    What have you tried already?  Are you having any specific difficulties?

    N
    nitesht9652
    September 17, 2021

    Hi,

    If are looking for examples to display some dynamically in the last row, i would suggest to look for Interface template REQUEST FORM example.(New Interface > Design Mode > Select Template.

    It has an editable grid which looks like would fit your use case.

    Terms & ConditionsAccessibility statement