Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ari_meta on 24 Mar 2010 04:39:32 AM

Title: counting non-zero values in cross-tab
Post by: ari_meta on 24 Mar 2010 04:39:32 AM
Hi

   i want to count non-zero values in the cross tab column wise. can any body give me some guidance.

Thanks

Ari
Title: Re: counting non-zero values in cross-tab
Post by: CognosPaul on 24 Mar 2010 05:07:41 AM
Are you on a relational or dimensional? Either way try something like this:
Code Select
count(1 within set filter([Product type],[Returns]>0))
Text only | Text with Images