I need to display blue color for max Revenue and red color for min Revenue by

I need to display blue color for max Revenue and red color
for min Revenue by using condition formatting how it
possible........?

Question Posted / nasa

1 Answers
6952 Views
I also Faced
E-Mail Answers

I need to display blue color for max Revenue and red color for min Revenue by using condition form..

Answer / nasa

first just find the max revenue and min revenue by using
singleton separately. after that write a condition.

if(list_query1.revenue=query2_maxrevenue) then ('Blue')
else
if(query1.revenue=query3_minrevenue) then ('Red')

i think it will work...

Is This Answer Correct ?

4 Yes

0 No

Post New Answer

More Cognos Interview Questions

What are the different types of OLAP. Which one is Cognos Powercube?

2 Answers HSBC,

explain project, package ,model , modelers.........and differences b/w them?

4 Answers HCL,

What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

0 Answers TCS,

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers Wipro,

What do you understand by the term 'dynamic cube'?

0 Answers

What is the size of the cube?

0 Answers

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers

Main Differnce between Cognos7 and Cognos8

1 Answers IBM,

cognos is holap or molap or rolap

7 Answers Cognizant,

Any Cognos planning Queries Rise