Print Page - HOW TO PERFORM A DISTINCT COUNT ?

Title: HOW TO PERFORM A DISTINCT COUNT ?
Post by: sanchoniathon on 30 Jun 2009 09:59:26 AM

Hi,

I have a data item in my query that has the following expression:
count(distinct [Material Real Key] for [Store Real Key])

I validate the report and NO error message.

I have a simple LIST with only 2 columns: [Store Real Key] and [Product Key]
I then create a footer by choosing "Store Real Key (footer)" for my list and validate still no error message.

I unlock my report, i then try to ADD the data item to the Footer but keep on getting this error:
OP-ERR-0088 A syntax error was detected near 'count'.

Anyone any ideas ?

Thanks in advance !

Title: Re: HOW TO PERFORM A DISTINCT COUNT ?
Post by: DustPanMan on 30 Jun 2009 10:53:25 AM

Create a custom calculation Summarization instead of adding the footer and manually updating it.

Title: Re: HOW TO PERFORM A DISTINCT COUNT ?
Post by: sanchoniathon on 30 Jun 2009 11:24:44 AM

Hi DustPanMan,

Can you provide step by step instructions please ?

Thanks !

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sanchoniathon on 30 Jun 2009 09:59:26 AM