If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Crosstab summary cell value calculate function

Started by Cognos8, 04 Jan 2016 10:53:35 AM

Previous topic - Next topic

Cognos8

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.

sdf

what is currently the output?

are you trying to put calculations on specific crosstab cells?

have you explored using singleton on those items?

cjsasaki

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