on 03-04-2022 9:47 PM
Hi Experts,
We have a business scenario in that IBP should calculate dynamically the actual qty proportionality (in percentage) of a certain location in the whole state (an aggregate attribution of location) or even for products in the same product family.
Example 1:
Example 2:
I was thinking if it's possible to use a kind of total function or even use aggregation between the planning levels to replicate this logic using only one key figure.
Hi vitor.camargo
Assuming that your KF1 and acutaly qty KF are both at the same planning level (e,g PL0), you can do the following.
Create a planning level PL1 with (PRD, state as root)
Create a planning level PL2 with (PRDFAMILY and State as root)
create a new KF(e.g KF2) at the same planning level as actual qty(e.g PL0) and use the below calculation level
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.