Hello All,
I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem.
My dataset is as follows;
<tbody>
</tbody>
If the returned results is greater than 9 mths of coverage, then formula should return "> 9 mths"
Thank you all in advance for your time and great help.
I'm currently looking for a way to calculate months on hand inventory. Looking around this forum I could not really find a simple way to get rid of my problem.
My dataset is as follows;
Model | Region | Configuration | Measure | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19 | Jun-19 | Jul-19 |
Model 1 | Region 1 | Configuration 1 | My sales forecast | 3 | 2 | 0 | 2 | 12 | 8 | 10 |
Model 1 | Region 1 | Configuration 1 | My inventory | 23 | 20 | 20 | 18 | 6 | -2 | -12 |
Model 1 | Region 1 | Configuration 1 | My Inventory cover (in mths) |
<tbody>
</tbody>
If the returned results is greater than 9 mths of coverage, then formula should return "> 9 mths"
Thank you all in advance for your time and great help.