How to create a Ratio in Cognos Report studio Reports?
- 1 Answers
- 12030 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / the_xxx
RATIO_TO_REPORT
This rank function calculates the ratio of a value to the
sum of the values for the entire set.
Syntax
RATIO_TO_REPORT( numeric )
Parameters
*
numeric-- Any numeric data type expression, typically
a reference to a numeric column.
Return Type
DOUBLE PRECISION.
Remarks
Returns a number for each row in the set that is the row’s
ratio to the sum of the entire set. When expression results
in NULL, the function returns NULL. When the sum of the set
is zero (0), the ratio is also zero.
Note: This function cannot be used as an argument in a set
function, moving set function, or rank function. For
example, SUM(RATIO_TO_REPORT(...)) is illegal.
Example
Determine what percentage each product sales is to the total
sales of all products for the last 20 weeks:
SELECT prod_description DESC,
SUM(dollars) as sales,
RATIO_TO_REPORT( SUM(
li_amount )) * 100 AS ratio_dollars
FROM lineitem, product
WHERE lineitem.li_prod_id = product.prod_id
GROUP BY prod_description;
DESC SALES RATIO_DOLLARS
Widget 896931.15 12.88
Basket 514830.00 7.39
Football 507022.35 7.28
Oil Drum 503493.10 7.23
Computer 437863.00 6.29
Chair 429637.75 6.17
Desk 424215.00 6.09
Mesh Bag 421205.75 6.05
Shoelace 417261.00 5.99
Powder 397102.50 5.70
Telephone 394086.50 5.66
Cord 392377.75 5.64
Mouse 389378.25 5.59
Monitor 305859.75 4.39
Case 294982.75 4.24
Cup 236772.75 3.40
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
how to merge 2 crosstabs thans
What are the considerations regarding performance kept in mind while setting up cognos?
i was asked what are the caluclations done by you in your report? plz give reply
What are types of batch available in cognos?
Why cognos decision stream is used?
------------------What is Inline Query?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
is cognos 7 is better than cognos 8
What do you understand by the term 'model durability'?
What are initial page components of Cognos connection?
What is the difference between Standard and Metrics folder?
how u will determine the performence tune will occur either in report or system
Define cognos report net?
