Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: aryanhanda on 15 Jul 2007 11:13:30 AM

Title: How to perform calculations in Measure part of Cross tab report
Post by: aryanhanda on 15 Jul 2007 11:13:30 AM
Hi,
I wanted to know how to perform calculations in the measure part of the cross tab report.I wanted to make  following calculation:-

(value displayed in a particular cell) *100/ (sum of total values displayed in all cell of that particular row )

I have even made different data items in te query to perform this calculation ,but its showing errors..

Can anyone please help me on this....
Title: Re: How to perform calculations in Measure part of Cross tab report
Post by: MDXpressor on 20 Jul 2007 06:10:05 PM
What is your datasource? (Relational:  Oracle, SQL, ...; Dimensional:  Powercubes...)
What are your errors?
Title: Re: How to perform calculations in Measure part of Cross tab report
Post by: aryanhanda on 21 Jul 2007 04:10:30 PM
Database is Oracle.Though its a crosstab report but I am getting some list report error..
Title: Re: How to perform calculations in Measure part of Cross tab report
Post by: MFGF on 24 Jul 2007 01:33:39 PM
Hi,

What errors are you getting exactly.  It's almost impossible to suggest what may be wrong unless you tell us exactly what errors you are getting...

Regards,

MF.
Text only | Text with Images