Print Page - Calculate Average For Single Item Below list

Title: Calculate Average For Single Item Below list
Post by: dbrooks74 on 22 Apr 2010 11:01:31 AM

Data:

Color	Value
Red	2
Blue	10
Green	7

Avg Blue: 53%

How do I create the calculation for the percentage? Basically I have a column for an item then I have a column for a value. I would like to a select value and divide that by the total values.

Is this possible?

Thanks

Title: Re: Calculate Average For Single Item Below list
Post by: MFGF on 22 Apr 2010 12:04:29 PM

Hi,

How about a calculation:

total([Value] for [Colour]) / total ([Value] for report)

Then format it as percent.

Does this give you what you need?

MF.

Title: Re: Calculate Average For Single Item Below list
Post by: dbrooks74 on 22 Apr 2010 01:16:22 PM

Thank you.

Sometimes it takes another set of eyes. I was trying to use the summary function rather than calculation. That works perfectly!

Title: Re: Calculate Average For Single Item Below list
Post by: MFGF on 23 Apr 2010 03:12:19 AM

You're welcome! :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dbrooks74 on 22 Apr 2010 11:01:31 AM