% calculation for list report

[Sakthi]

Hi Friends,

I using just a simple list report and trying it hard to display appropriate % calculation column.
Here is the scenario, there are 3 columns namely Title, Count and %. And at the summary there is a total for count.
Title         Count       %
Employer        6              24%
employee        3              12%
pathfinder     3              12%
Agent       13      52%
-------------------------------------
Total         25         
-------------------------------------

Here the Title and count coming directly from DB and i'm calculating % with the formula Count/Total * 100

I'm always getting 100% in the % column.
Any help will be much appreciated.

[Lynn]

try using a total function for the denominator:

[Count] / total( [Count] for report )

[Rahul Ganguli]

Hi,

If you are using COgnos 10, then just select count column and right click-->Calculate-->% to Total
This does teh same thing whcih is mentioned by Lynn.

Regards,
Rahul