Hi. I want to make an App Formula that can su...

(Felix Tay) #1

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])’

(Praveen Seshadri (AppSheet)) #2

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