I have a requirement to calculate the value in percentage:
For a material 1004,i have customer code values like 102,103,104,105 and for each customer codes i have a forecast keyfigure value like 200,300,400,500.
Now i want to calculate the percentage value for each customer code of the material 1004.
Eg: Material customer code forcecast keyfigure
1004 102 200
Customer code 102 percentage value should be (200/1400)*100
Calculation should be dynamic, because for another material there may be more customer codes?