Appsheet Order Capture Sample

[Emery]

I am working on an order capture app using the Starter template. In the template the amount available is incorrect because it is still counting the Canceled order as Requested item. I am trying to create a formula to only count the requested item if the order status is set to open or Complete.

I tried something like this, but while the formula is valid it is not working for what i want

SUM ( SELECT (Order Details[Quantity],
AND([Product ID] = [_THISROW].[Product ID],IN("Order Details[Order Status]",
{"Complete", "Open"}))))

[diogolupcosta · Accepted solution]

SUM(
SELECT(Order Details[Quantity],
AND(
[Product ID] = [_THISROW].[Product ID],
 OR(
  [Order Status] = "Complete",
  [Order Status] = "Open"
 )
)))

[Emery]

Thanks tons