Sum in tables

[Yasin_Hassanien]

I need to create a row by the end of each table to calculate a sum of the column values at the end.

Please check the sample

[Venkatakonda_Re]

Hi Yasin,

I think you can use below formula to get the sum of the column.

SUM(Classes[Seat Count])` : The sum of all values in the Seat Count column of the Classes table.

Refer this link: https://help.appsheet.com/en/articles/2357307-sum

[Yasin_Hassanien]

But I need a row in the end of the table to show this, so how Can I achieve this ?

[Steve]

Yasin_Hassanien:

how Can I achieve this ?

It’s not possible to have a summation row in a table without a very complex setup.

[Yasin_Hassanien]

@Steve what do you think?

[Koichi_Tsuji]

This sample App I made before may help.

https://www.appsheet.com/samples/Public-Sample-App?appGuidString=f208a9d1-8c5b-4221-8d9c-62dfcc032fc...

@Steve
@Aleksi

[Chee]

Hi Koichi,

I need help on doing a total like the sample you have posted here. However, the sample is no longer available in this link. Can u help to share again? Will help me tremendously. Thanks.

[Aleksi]

The easiest way to create this kind of functionality… add a simple text column to your table and use initial value “TOTAL”. Then group this table view with that column and aggregate the view with that same column. Then it will show the total like… TOTAL (318). Though it’s not in the end.