Hi. I want to make an App Formula that can sum up L1-L15 and display them in “Total”. I only want the summation to be calculated from ONE row only. How do I make that happen?
In Google Sheets it’s as simple as ‘=sum(AU2:BI2)’. Tried this in Appsheet but it didnt work:
‘SUM([L1],[L2],[L3],[L4],[L5],[L6],[L7],[L8],[L9],[L10],[L11],[L12],[L13],[L14],[L15])’
Try [L1] + {L2] + .[L3] + … + [L15]
When I see something like this, it is often an indication that the data is pivoted. For example, each of these columns represents the sales in a region, and you want to get the total sales.
In a spreadsheet, you are sometimes encouraged to pivot your data so that you see it this way. But in AppSheet (as in a database system), we’d encourage you to flatten/unpivot the data. Each row should contain the region and the sales for that region. You’d have many rows and then sum across the rows, not across columns.
help.appsheet.com - Using Spreadsheets with Pivoted Data
Using Spreadsheets with Pivoted Data help.appsheet.com
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |