Get sum of a table column in a label

How do I do X?
1

I have a table data in my Appsmith application and I need to calculate the total of specific column in a label

2

Hello, if you are using server-side pagination, you can write a query to do this. If you are using client side pagination, you can use the lodash sumBy function to sum the data
{{ _.sumBy(Table1.tableData, (row) => row.columnName) }}

3

Thanks Nikhil for your reply
Really I don’t know more about pagination
I only connected a SQL server database to my application and show its data inside a table as shown on the attached photo

I need to sum the value for Cash and the value for the VISA on the labels under the table
I hope you can help me with this

Capture
Capture1204Ă—780 68.8 KB

4

This should work
{{ _.sumBy(Table1.tableData, (row) => row.Visa) }}

5

I did it but it show empty label

image
image1091Ă—787 49.4 KB

6

Can you share a screenshot of the query result that you use to populate the Table widget? Is the name of the field returned by your query exactly “Visa”?

7

i want page wise totals pls suggest formula

8

Hey @nagaraju, Can you please elaborate on what you mean by page wise total?

9

Thank u for ur quick response
i have a table widget in that i have multiple pages
, in that table have Amount Column, i want to show the Amount Total page wise(displaying values total only), when i change the page it will update automatically , but now it is showing total pages summery only

want page wise totals
want page wise totals1439Ă—660 124 KB

10

Alright.
Are you using server-side pagination for your table?

11

no i am using client side pagination

12

Alright. Can you try this and see if it works for you?

{{_.sumBy(Table1.tableData.slice(Table1.pageOffset, Table1.pageOffset + Table1.pageSize), (row) => row.amount)}}

1 Like
13

Thank u it’s worked , and also when apply sorting or Filters from client side can I get sum dynamically ?

14

Hey! What do you mean by dynamic?

With the snippet that Olawale gave you, it’s should be dynamic already from what I understand. If I am missing something, can you share a loom video and point out the issue.