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
- 7887 Views
- Kudos India, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pooja
Why do we need to do that? i mean why do we need to display
revenue of 2 years, when we are choosing a particular year
to display the value? What is the scenario?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / uzval_vee
by using expressions, i mean by using conditional
constructs and thru graphs we can view the revenue and
caliculated data as well.
| Is This Answer Correct ? | 0 Yes | 1 No |
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
------------------- What is Busschema?
Explain the different stages in creating a report in cognos report net?
what is the difference b/w mdx and sql?
Can u please describe the different types of traps with eg. Thanks
What are all the types of report?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
What is a Framework manager?
Explain the Difference Between Bursting and Scheduling?
What is limited local? and the uses?
What are types of batch available in cognos?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
Teradata 
