Skip to Content
Former Member
Sep 03, 2012 at 02:31 PM

How to get the percentage value


Hi guys,

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

103 300

104 400

105 500

Customer code 102 percentage value should be (200/1400)*100

Calculation should be dynamic, because for another material there may be more customer codes?