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.
Try: SUM(SELECT(BOLs[Incoming Amount],AND([Lot #]=[_THISROW].[Lot #],[Packaging]=[_THISROW].[Packaging])))
@Jason_Denniston Thanks for the response.
I gave that a try and got the same results โ it passes โverifyโ, โtestโ produces the correct results, but it will not preview in the app.
@Autumn_Steinert Preview in the app on your phone or the simulator?
@Jason_Denniston In the simulator (on the desktop)
How does it look on your phone?
If it looks ok on your phone, I would notify AppSheet or get a hold of a moderator in this community and notify them as this is, most likely, a bug in the simulator. Iโve only been playing with this for 3 weeks and have noticed a few bugs here and there.
Also, make sure your data types arenโt conflicting as Iโm sure they arenโtโฆbut just double check to make sure.
@Autumn_Steinert Maybe the column isnโt being included in your viewโs column order setting? Or if youโre using a slice, maybe your virtual column isnโt included in the slice?
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |