Exception (colouring cells) in report output based on formula.

[Former Member]

Hi Gurus,

I want to colour my cells in report output. But this coloring is not so simple. It has to be done based on a formula.

Lets say i have material in rows and sales value by period in columns.

.......................Jan'08......Feb'08.......Mar'08.....Apr'08

Material A...........100..........120............105.........140

If Feb'08 values is greater than 0,02*Jan'08 value than ---> Feb'08 has to be coloured as green. etc.

Is it possible to define such a rule for the exception?

Thanks

S.P.

[former_member181964]

Hi,

You calculate the required results using Formulas and then create the Exception. Split the calculations and do it.

Thanks

Reddy

[Former Member]

Hi Reddy,

I am using bex 7.0.

I tried that also.

I created another formula in columns with name "Difference" and it calculates the difference.

Report looks like as below:

Material.....Jan'08.......Feb'08.....Difference

ABC............100............120.............0,2

Now, I have to colour Feb'08 column, based on the value under Difference column. But it does not work.

In Exception settings; from Definition tab, I selected Difference column (exception is based on).

In Display tab, I select Feb'08 column.

But it does not work.

Any idea?

Thanks

S.P.

[Former Member]

It can be done using table interface if you are in BW3.5

[Former Member]

Hi Venkat,

I am using 7.0 but couldn't understand what do you mean by table interface?

Thanks.

S.P.