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



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

Name the types of report?

0 Answers  


How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.

5 Answers   IBM,


Can you explain dynamic query mode?

0 Answers  


1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

2 Answers   IBM,


1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  






what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

7 Answers   Cap Gemini, iFlex,


data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,


how to perform single sign in cognos by using url?

0 Answers   IBM,


wat is called Model dimension?

0 Answers   IBM,


What are the differences between Cognos 8 and Cognos 7.x version?

2 Answers  


what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

0 Answers   HCL,


what are the applications of the tabular model ????

5 Answers   iFlex, iGate,


Categories