I have three tables, an “Orders” table, a “Units” table and a “Pallets” table.
There is a reference between “Orders” and “Units” and between “Units” and “Pallets”. So, a unit belongs to an order, and a unit is placed on a pallet. There is no direct relation between pallets and orders.
However, I’d like to get a list of all the pallets that contain units which belong to a specific order.
I have tried with a formula in the “Orders” table like this:
SELECT(Pallets[UID], IN([UID], SELECT(Units[Location (pallet)], [ION] = [_thisrow].[ION])))
This formula does retrieve the correct pallets but the sum that Appsheet automatically creates a the top of the list seems to sum the amount of units (the inner SELECT() statement), rather than the amount of pallets. Is this a bug? And is there anything I can do about it?