Interested to Buy Any Domain ? << Click Here >> for more details...
How to findout YEAR CALCULATION?
THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE.
WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY
THIS YEAR RESULT AND LAST YEAR RESULT.
- 3 Answers
- 7723 Views
- Kudos India, I also Faced
- E-Mail Answers
Answer Posted / nasa
scenario:
Display 2013 and 2014 revenue and compare that country wise?
report studio-> list-> drag and drop a country data item
from branch query subject
drag a QUERY CAL from tool box drop beside country column
Name: 2013_revenue
expression:
if(order_year=2013) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2013_revenue
column
Name: 2014_revenue
expression:
if(order_year=2014) then(sales.revenue)
else(0)
drag a QUERY CAL from tool box drop beside 2014_revenue
column
Name: variance_between_2013 and 2014
expression:
2014_variance - 2013_variance
ok
save and run
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of powerhouse?
Explain the difference between powerplay transformer and power play reports?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
How to publish a package by running Java Script?
what is the main advantage of impromptu over cognos reportnet?
-----------------What is Direct and Conventional loading?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What is zero-foot print?
Can you define a catalog and types of catalogs in cognos?
What do you understand by the term 'model durability'?
How do we convert from Numeric to be Words?
please please give me some banking calculations in framework manager.
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is difference between page break and section report?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
