% Of sales if no structure in lines

[former_member288630]

In a Profit and Loss Account, I want to calculate all my lines in % of sales. In the report I don´t want to use a structure in lines. So the solution of cell doesn´t work.

Example:

Sales 100 100%

Margin 30 30%

Cost -12 -12%

Result 18 18%

In line I have cost elements with or without hierarchy. Do soemone have a solution in order to create the column %...? If I have to use CKF, please be very precise as I tried and couldn´t find the solution.

Regards

[Former Member]

Hi

Hide the key figure and use the formula

(Key figure%A100) next in the column and use this column to display

Here Key figure is the one which your getting without %like 100,12...instead now you will get 100%...

You will get % next to all your columns

Regards

N Ganesh

[former_member288630]

Hi Ganesh,

Thank you for your answer, but what I want to do is to calculate the % of margin, cost and result over sales... So in this case margin % will be :

(margin / sales * 100) so (30/100*100) = 30%

The problem is sales, margin,... are same caracteristic, in this case cost elements.When I´m using formulas in order to calculate the % of sales, is calculating % only for sales and not calculating for other caracteristics...

Any solution?