How to get the Category Forecast at item level using measure expression in demand management
Summary:
The problem statement is that we need to use category forecast number at item level for further calculation using measure expression.
For Example - In one category we have 3 items item1, item2 and item3. The category level forecast is 1000. so user will provide forecast split percentage (editable measure) at item level 40%,40% and 20% to those 3 items at item level. Now We need multiply that split percentage value with category level forecast number which is 1000 so final forecast at item level would be item1 = 400, item2 = 400 and item3 = 200.
We would like to hear any other solution approach on this if it's not possible using measure expression? Thanks!
Tagged:
0