Skip to Content
author's profile photo Former Member
Former Member

% Of sales if no structure in lines

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 05:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.