Hi Everyone,
I am looking for a way to build a formula to look at Customer Requests by date compared to inventory. My customer requested are already added into my ending inventory on my report*. So if there is a customer request I need a formula to check if our inventory was positive during that time. Here is an example of my table.
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
I am looking for a way to build a formula to look at Customer Requests by date compared to inventory. My customer requested are already added into my ending inventory on my report*. So if there is a customer request I need a formula to check if our inventory was positive during that time. Here is an example of my table.
<colgroup><col><col><col><col span="3"></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Customer Requested | 11/19/2018 | 11/20/2018 | 11/21/2018 | 11/22/2018 | 11/23/2018 |
Texas | 300 | | | | |
Kentucky | | 200 | 400 | | |
California | 200 | 200 | | | |
<tbody>
</tbody>
Running Inventory | 11/19/2018 | 11/20/2018 | 11/21/2018 | 11/22/2018 | 11/23/2018 |
Inventory-Texas | -200 | 300 | 1400 | 1600 | |
Inventory-Kentucky | | 500 | 700 | 200 | 100 |
Inventory-California | 300 | 50 | | | |
<tbody>
</tbody>