how can create a report like if the salary>50,000 display
balance,if salary<50,000 display green?
Answer Posted / arun kiran
In c8 you can achieve this by following these steps
1)drag a conditional block
2) Assign a boolean variable(in expression box if(sal>50k)
to the conditional block
3) go to conditional explorer you find two conditions yes and no
4)when current block is yes...drag a layout calulation (sal-50k)
5) When current block is no... use select background color
of salary as gree
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is difference between data mart and data warehouse?
Can you explain cognos planning?
Is it possible to join multiple Databases in a Catalog?
What are the advantages of using cognos sql?
What is set to be Cognos configuration?
What is the difference b/w macros and prompt?
What are the main services provided by application tier?
How to Reset Pagenumbers in one report.
What are all the different types of prompt in cognos?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
please please give me some banking calculations in framework manager.