Help with SELECT statement
I’m trying to replace a spreadsheet SUMIF formula with an APPSheet Sum(SELECT) statement, but I’m having some trouble.
When I put the statement in AppSheet, it verifies the statement as correct and values will show up when I Test, but when I set preview the app no values are shown.
My statement is: =SUM(SELECT(BOLs[Incoming Amount],AND([_THISROW].[Lot #]=[Lot #],[_THISROW].[Packaging]=[Packaging])))
Its intent is to sum the quantity of product received.
So the BOLs table has a list of individual deliveries.
The table containing this expression contains a unique list of product that should summarize the values.
This expression is supposed to go to the BOLs table and sum the values where Lot # and Packaging match what is on this row so I get a total.
Can anyone see why my expression isn’t displaying correctly?
It passes the Verify and when I TEST it produces values, but it won’t display them in the app preview.
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |