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

Percentage Rows in Report painter .. Urgent Please

Hi All,

I have rows where I need to calculate percentages, Can you please advise how to calculate.

Loong Hin Pang - I have seen you answering one related query. Can you please help me out.

Points for sure...

Regards,

Kiran.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2008 at 08:39 AM

    That is simple

    ( ( X001 - X002 ) / X002 ) * 100

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2008 at 08:49 AM

    Thank you.

    See I have the below Rows

    Total Revenue

    Cost2

    Cost3

    Direct Cost

    Gross = Total revenue - Direct Cost

    Gross % = (Gross/Total revenue ) * 100

    I have Columns as with basic Key figures and Formulas

    Year(basic key Figure)

    Year+1(basic key Figure)

    Total = Year + (Year+1)

    Its giving me correct values in case of Basic Key figures and not in the formula case.

    It giving error when there is formula both in Row and Column.

    In the above case last row and last colum. Only Column formula is getting implemented.

    Here for example I have mentioned 4 rows and 4 columns.. But I have 15 Rows and 30 columns .. out of which 15 rows and columns have formulas...

    % Rows are problem.. which gives me errors... I tried using Special cells, but I am not 100% sure how to use them.

    I would be very thankful if you can help me out.. Please

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As far as I have understood, in row there will be a formula for Gross % which will use 2 row values i.e. gross and total revenue. This will use the Y variables for row

      Now in columns, you will have two basic key figures and third column as Sum of the first two columns and further combinations for the other columns. This will use X variables for the columns.

      So, if there is a specific cell which is to be used for the entire column, then only special cell processing is applicable. Else it should be working with the above logic.

      Sorry, if I am not much more helpful.

      Ramanand

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.