Print Page - Crosstab summary cell value calculate function

Title: Crosstab summary cell value calculate function
Post by: Cognos8 on 04 Jan 2016 10:53:35 AM

I have a crosstab output in the attached format. In the red shaded cell i need to calculate in the format
G5 = F5/F9 , I5= H5/H9, G8 = F8/F9 , I8 = H8/H9. I have updated the value in the cell as well. Please refer the
attachment, you will get a clear idea. same calculation works in List but not in crosstab. This is relation model.I have played
around with total and round_total function with for. nothing is working out.

Title: Re: Crosstab summary cell value calculate function
Post by: sdf on 06 Jan 2016 12:24:49 AM

what is currently the output?

are you trying to put calculations on specific crosstab cells?

have you explored using singleton on those items?

Title: Re: Crosstab summary cell value calculate function
Post by: cjsasaki on 17 Feb 2016 04:00:35 PM

Hi

I just made a similar question on the forum.
Please can you help me?

http://www.cognoise.com/index.php/topic,30119.0.html

I have a CrossTab and I want to make some calculations between rows.

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognos8 on 04 Jan 2016 10:53:35 AM