Total/Subtotal of a row

AppSheet AppSheet Q&A
1

Hello,

I am trying to follow this post to create a row that shows totals, but I’m a bit lost.

What I have:
Table Name: Devices
Columns: Serial Number / Device Type / Price1 / Price2
I want to show the total of “Price1” and “Price2” as a value in the table view

This is what I understand from the post:

  1. In the table, I add a row with the value “Total” in the “Device Type” column.
  2. I create an action “set the values of some columns in this row”, formula:
    Sum(Select(Devices[Price1], [Device Type]<>Total))
    this one is accepted and it works
  3. Then I create another action “execute an action on a set of rows”
    Table: Devices
    Ref Table: Devices
    Ref rows - this is where I am struggling, according to the post, I can use something like
    " select(TableName[ID],[Category]=“Total”) "
    updated to match my data
    " Select(Devices[Serial Number],[Device Type]=“Total”) "
    This one gives me an error “The value of data action ‘Subtotal’ does not match the expected type List or its expected type details”

Usually the Ref Rows formula was a list of rows from a column, but I don’t know how to add a condition to what this list should contain.

Can you please point me in the right direction?

Thank you in advance!

2

Instead of:

Select(Devices[Serial Number],[Device Type]=“Total”)

Try:

FILTER(“Devices” , [Device Type] = “Total”)

1 Like
3

Ok, that was easier than I expected, I didn’t consider using FILTER at all, my bad.

Thanks a lot for the quick and easy solution!

1 Like
4

Hi razvan

I think i have solution for this one,

u add some expression in display name of your column,

for Price1 column u can use this:

Price1&" (“&text(sum(Devices[Price1]))&”)"

Hope this helps you.