Interested to Buy Any Domain ? << Click Here >> for more details...
How do you use SUM function in Reportnet?
- 3 Answers
- 9992 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lalitha
We have total() function in Expression Definition.
We can right click on the column and in functions block we
have total() function
| Is This Answer Correct ? | 4 Yes | 0 No |
in expression we can use this functions
ans by ambareesh.ko@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Sales person are there in one company How to do Bursting on this particular requirement?
what is filter?give me one example that you created a report in your project?
how can I test reports in cagnos?
What are the different uses of a repository manager?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
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 filter?give me one example that you created a report in your project?
How can we find out cardinality between two tables?
How can we do the unit testing?
What are the themes in a data warehouse?
Teradata 
