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

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2427

---

What is the use of powerplay web viewer in cognos?

1077

---

What is Metrics designer?

1022

---

What is a Datastore in Cognos?

1281

---

What do you understand by the term 'aggregate cache'?

973

---

what is online view?

1935

---

What is the difference b/w macros and prompt?

1119

---

What are slice and dice?

920

---

what are the errors faced while bursting the reports and how to solve those errors?

2007

---

What is the difference between drill through, drill across?

1079

---

Can you define fan trap?

1260

---

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2755

---

What is catalog and types of catalogs in cagonos and which is better?

996

---

How do we drill through from a powerplay cube to reportnet?\

2343

---

Explain is there any comparison available for cognos reportnet vs crystal reports?

949

---