If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Formatting

Started by Toushila, 29 May 2008 03:47:59 PM

Previous topic - Next topic

Toushila

Hi Friends,

I need a favor from you all.....In the report there are 2 listed queries with  same columns. 1st list shows detailed data and 2nd list is Summary data.

I need to do conditional formatting for the same clolumn in the 2 lists queries.

The condition is: 

If(percentage of Revenue >= 60) then ('Green') else if(Percentage of Revenue < 60) then ('Red')

I created a String variable and added 2 values Green and Red. In Properties assigned Conditional style to Percentage of Revenue column of 1st list query.
In Conditional Explorer Assigned the Green and Red colours as background to the column.

When I run the report I see only Red color is being assigned to 75% also which should show Green color.

Can someone throw some light what I'm doing wrong here?

Also I need to do the same conditional formatting for the 2nd list query for the same column. Please help me achieve this.

Thank you all in advance for the help extended.

Cheers,
Toushila

Gopinath

Go for Boolean Variable if your condition returns only 2 values.

Check whether you have applied the condition properly to the fields.

If the 2nd list is based on the same query(list1) then apply the same Variable on it, else create a new conditional variable using the data item from the 2nd list and apply.

Toushila

Hi Gobinath,

Thanks for your suggestion. Actually I've 2 lists as 2 queries. List 1 is Query 1 and Lsit 2 is Query 2. So As suggested I created 2 String variables and tried, still everything becomes RED color irrespective if is <= 60 OR > 60.

I tried to use Boolean, here also it shows only RED color.

Steps followed:
1. Created a String Variable for List1 -> Qual

2. In Expression Editior
If(percent of Quality Revenue >= 60) then ('Green') else if(percent of QualityRevenue < 60) then ('Red')
3. Added 2 values--> Green and Red
4. Clicked OK
5. Hightlighted column  percent of Quality Revenue and in Properties clicked the Conditional setting: chose Qual Variable and clikced OK
6.Column still selected clicked the Conditional Explorer and clicked Green and selected Background color in Properties as Lime Green and double cliked the Conditional Explorer.
7. Column still selected clikced Red and clicked Green and selected Background color in Properties as Red and double cliked the Conditional Explorer.
8. Ran the report.

It highlights the column as RED irrespective of >= 60 OR < 60.

Please let me know how to resolve this. Any help is appreciated as I need to submit the report.

Thanks in advance!

Toushila






Gopinath

Toushila,

I think you are applying conditional variable on a formatted column(%). The actual value of the field would be 0.6 so, Use the actual value in the condition.

If(percent of Quality Revenue >= 0.6) then ('Green') else if(percent of QualityRevenue < 0.6) then ('Red')



Toushila

Hi Gobinath,

Thanks a lot! Itworks.

Cheers,
Toushila