cancel
Showing results for 
Search instead for 
Did you mean: 

reporting exception

Former Member
0 Kudos

I have a bex report with the characteristic as <b>product</b> and key figures as <b>plan, actuals</b>. i have created <b>variance</b> using a formulae. I have created an exception for <b>variance</b> with positive values given green colour, negative value given red colours, and 0 as yellow colour, I want to have the report in such a way that the exception colours for variance apply to the actual and i do not have variance coloumn in the final report

Accepted Solutions (1)

Accepted Solutions (1)

former_member188325
Active Contributor
0 Kudos

if i have understood u r requirement correctly,

Hide 'Variance' column.

go to Properties of 'Variance' -->Set Hide to 'always hide'.

Thanks

Former Member
0 Kudos

hi murali,

would like the exception colours of <b>variance</b> to be applied to <b>actual</b> pls work on that

former_member188325
Active Contributor
0 Kudos

whats u r formula exactly?

Former Member
0 Kudos

formulae for variance is

variance=actual-plan.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can achieve this in a workbook. I am trying out some other logic in BEx, will get back to you if succeeded.

Former Member
0 Kudos

AVR,

can u explain in detail how we can achieve in a workbook

Former Member
0 Kudos

Hi Raj,

You can write code for macro putting you logic without variance column. A macro would let you to give colors based on the condition. Macro is not a difficult task. Just check if you have anyone who know VB. It will work out. Hope this helps you.....

Former Member
0 Kudos

AVR,

without using VB or macro we should be able to do directly in BEX itself.