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"}))))
Solved! Go to Solution.
SUM(
SELECT(Order Details[Quantity],
AND(
[Product ID] = [_THISROW].[Product ID],
OR(
[Order Status] = "Complete",
[Order Status] = "Open"
)
)))
SUM(
SELECT(Order Details[Quantity],
AND(
[Product ID] = [_THISROW].[Product ID],
OR(
[Order Status] = "Complete",
[Order Status] = "Open"
)
)))
Thanks tons
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |