Calculate the sum of the column

AppSheet AppSheet Q&A
1
Show More

I WANT TO CALCULATE THE SUM OF THE COLUMN AND NOT THE SUM OF THE ROW IN APPSHEET

SharedScreenshot.jpg
SharedScreenshot.jpg573×147 22.6 KB

2

SUM() - AppSheet Help

3

Just to clarify, you are wanting the SUM for EACH column. There is not an AppSheet supplied easy way to get a view like you are showing. You will need to build that view.

However, to get the SUM for one of those columns you would an expression like this:

SUM(Your Table Name[Product 1])

This is a shorthand expression for:

SUM(SELECT(Your Table Name[Product 1], TRUE)) 

Note “Your Table Name” needs to be replaced with the specific table your columns are in. For other columns, adjust and apply this expression for each of the columns you wish to be SUMmed.

SUM()

1 Like