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.

Points for sure...

Regards,

Kiran.

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Mar 31, 2008 at 08:39 AM

That is simple

( ( X001 - X002 ) / X002 ) * 100

10|10000 characters needed characters exceeded
• 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

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