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.
try using a total function for the denominator:
[Count] / total( [Count] for report )
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