converting counts into percent of columns - please help!

[CognosNewbie24]

Hi - I need help with the command to convert this table from counts to percents of the total. Is there an easy trick to this?

[bdbits]

You've not really provided enough information for someone to help.

Please see our etiquette post at http://www.cognoise.com/index.php/topic,24030.0.html and repost with more information.

Most likely, you will need to change the expression currently showing you the counts.

[tjohnson3050]

'Percent of' calculations require you to learn the 'FOR' argument that works with all aggregate functions.  Here is a good paper on it:

ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/advanced_report_design/using_the_at_and_for_options_with_relational_summary_functions.pdf