Percentage Rows in Report painter .. Urgent Please

[Former Member]

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.

[Former Member · Accepted solution]

That is simple

( ( X001 - X002 ) / X002 ) * 100

[Former Member]

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

[Former Member]

Hi,

Make the Gross Row cells as special processing ones. Thereafter in the Gross % row formual, use the field of Gross Value which will be having code starting with "Z" and the Revenue field having code starting with "X".

Hope it helps.

Ramanand

[Former Member]

Thats right. But I have one concern here i.e. If I make all the values in Gross as Special cells, it will give many Z variables. In formula for the row, which Z cell should we use ? I am new to this special cells, so can you explain me in detail.

Thanks a lot!!!

Regards,

Kiran.

[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