COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: knip on 09 Feb 2013 08:57:03 AM

Title: Finding Percentage
Post by: knip on 09 Feb 2013 08:57:03 AM
Hi,
    I have a list report which displays 3  measures A,B,C, this A,B,C is the run time total value obtained, how can i use this run time values , which i will be using in calculating my percentage?

Kind Regards
Title: Re: Finding Percentage
Post by: blom0344 on 11 Feb 2013 01:53:09 AM
You may getter better feedback posting an example with data and where you are after. 'Calculating my percentage' is a bit vague..
Title: Re: Finding Percentage
Post by: bi4u2 on 12 Feb 2013 10:34:49 AM
Knip, you might have to create some data items to calculate the numerator and denominator for the percentage calculation. For example:

TOTAL( [A] for grouping) / TOTAL ( for grouping)