SUM(SELECT expression won't work on a input defined column

AppSheet AppSheet Q&A
1

So I have been working on a user input filter based dashboard. The goal of the app is to assist in production planing activities.

The structure is straightforward: select open orders from a enumlist and specific columns in a table will change to reflect the quantities associated with the selected orders I have all my filters working fine but the I cannot get enumlist to SUM.

The formula for my filtered column is as follows SUM(SELECT([Ref column of a filtered slice][Quantity],[Product Id]=[_THISROW].[Product Id]))`

If i tick off one value in the enumlist I see the appropriate value in the appropriate field but if I start to tick off multiple items in the list the values go back to 0.

The structure of this app is based on the Order Sample app. There are 3 tables, Orders, Order Details, and Inventory all with ref. I have tried both both virtual and non-virtual columns with the results being the same.

2

What happens if you remove the SUM expression away? Does it show multiple numbers?

3

Replace this:

[Product Id]=[_THISROW].[Product Id]

With this:

IN([Product Id], [_THISROW].[Product Id])
4

Regardless, if I remove the SUM expression the behavior is the same (one selection appears in the column, more than one the selection disappears)

5

It sounds that you need IN expression as @Steve proposed.

1 Like
6

@Aleksi

2X_b_be521088c9c14c95ac9c0a86640424175225ae18.png
2X_b_be521088c9c14c95ac9c0a86640424175225ae18.png872×228 12.6 KB

7

Is it okay if I check your app? Then we would not need to guess. For that, I would need to know your account ID, app, table and column name. Thanks

8

That would be great Ill PM you the info

9

Your Product ID is set to number but it’s a text. Try to change it first to text.> > You can also write the formula like… SUM(SELECT([Related Order Details][Quantity],TRUE)). The [Product Id]=[_THISROW].[Product Id] is not needed because [Related Order Details] is already a list of child records.

Yes.I changed the column type back and streamlined the formula (must have gotten switched when I was troubleshooting, originally I thought it was column type issue).

The behavior still persists. What about the IN expression? Perhaps incorporating that into the formula? I am just unclear on how to proceed