Print Page - Percentage in Crosstab

Title: Percentage in Crosstab
Post by: sschmelz on 18 Sep 2013 11:16:23 AM

Hi,

I have got a crosstab of the following form:

#Result Passed Failed Blocked SUM
Testplan 1 5 10 15
Testplan 2 4 9 1 15
..
Testplan x 2 3 3 8

for the y-axis I use a data item [Testplan], for the x-axis a data item [Verdict], I am counting on [Result-ID].

How can I add a column "Percent Passed", which contains the percentage of "Passed" executions per Testplan?

Title: Re: Percentage in Crosstab
Post by: sschmelz on 23 Sep 2013 10:12:08 PM

Hmm, nobody any idea?

My intended result would be like:

#result. Passed. Failed. Blocked. SUM. %passed
Testplan 1. 5. 10. 15. 33
Testplan 2. 4. 9. 1. 15. 27
....
Testplan x. 2 3. 3. 8. 25

Title: Re: Percentage in Crosstab
Post by: adik on 24 Sep 2013 03:34:55 AM

%passed query item would be something like: [sum]/total([sum] for report)*100

Title: Re: Percentage in Crosstab
Post by: sschmelz on 24 Sep 2013 07:05:27 AM

Thank you... well I know how to get a percentage. I am struggling with the exclusive count for "Passed" within [Verdict] to be used in that calculation?
Any idea for that?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sschmelz on 18 Sep 2013 11:16:23 AM