Forum Discussion
Formula Help
How can I determine if all the rows that share a particular order # have inventory to ship Order #400001 complete.
| Report Date | Order # | Scheduled Date | Description | Inventory | Items Needed | Is Their Enough Inventory On Hand To Ship Order Complete | WHICH ORDER NUMBERS |
| 11/7/2020 | 400000 | 11/7/2020 | Widget #1 | 1000 | 25 | YES | |
| 11/7/2020 | 400001 | 11/7/2020 | Widget #1 | 1000 | 20 | YES | |
| 11/7/2020 | 400001 | 11/7/2020 | Widget #2 | 2 | 4 | FALSE | |
| 11/7/2020 | 400001 | 11/7/2020 | Widget #3 | 55 | 11 | YES | |
| 11/7/2020 | 400002 | 11/7/2020 | Widget #3 | 55 | 13 | YES |
Here is a column you can put on your orders table to indicate if there is sufficient inventory for each item. It also works as a measure expression that will work in a table visual with the Order # column.
Enough =
IF (
ISBLANK (
CALCULATE (
COUNT ( Orders[Order #] ),
FILTER (
ALLEXCEPT (
Orders,
Orders[Order #]
),
Orders[Inventory] < Orders[Items Needed]
)
)
),
"Y",
"N"
)Regards,
Pat
1 Reply
Here is a column you can put on your orders table to indicate if there is sufficient inventory for each item. It also works as a measure expression that will work in a table visual with the Order # column.
Enough =
IF (
ISBLANK (
CALCULATE (
COUNT ( Orders[Order #] ),
FILTER (
ALLEXCEPT (
Orders,
Orders[Order #]
),
Orders[Inventory] < Orders[Items Needed]
)
)
),
"Y",
"N"
)Regards,
Pat