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;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Region[/TD]
[TD]Configuration[/TD]
[TD]Measure[/TD]
[TD]Jan-19[/TD]
[TD]Feb-19[/TD]
[TD]Mar-19[/TD]
[TD]Apr-19[/TD]
[TD]May-19[/TD]
[TD]Jun-19[/TD]
[TD]Jul-19[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My sales forecast[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]12[/TD]
[TD]8[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My inventory[/TD]
[TD]23[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]18[/TD]
[TD]6[/TD]
[TD]-2[/TD]
[TD]-12[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My Inventory cover (in mths)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Region[/TD]
[TD]Configuration[/TD]
[TD]Measure[/TD]
[TD]Jan-19[/TD]
[TD]Feb-19[/TD]
[TD]Mar-19[/TD]
[TD]Apr-19[/TD]
[TD]May-19[/TD]
[TD]Jun-19[/TD]
[TD]Jul-19[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My sales forecast[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]12[/TD]
[TD]8[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My inventory[/TD]
[TD]23[/TD]
[TD]20[/TD]
[TD]20[/TD]
[TD]18[/TD]
[TD]6[/TD]
[TD]-2[/TD]
[TD]-12[/TD]
[/TR]
[TR]
[TD]Model 1[/TD]
[TD]Region 1[/TD]
[TD]Configuration 1[/TD]
[TD]My Inventory cover (in mths)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.