Print Page - How can i get the Countif Excel Function in Analyst

Title: How can i get the Countif Excel Function in Analyst
Post by: Moreshwar on 07 Jun 2010 05:34:16 AM

I want to take the count of rows based on a data field. It is similar like the Excel Countif function. Please let me know if there is any way to do this.

Thanks
Moreshwar

Title: Re: How can i get the Countif Excel Function in Analyst
Post by: craig_karr on 07 Jun 2010 08:20:42 AM

I am not sure I understand how your model looks like, but would it be possible to add a new column and that couln should have a new calculation which should be IF <condition met> THEN 1 else 0

and then you could just make a summary row for the rows and then the summary row would contain the value youre looking for in the new column

Title: Re: How can i get the Countif Excel Function in Analyst
Post by: Moreshwar on 07 Jun 2010 09:10:57 AM

Hi Craig,

Thanks for the reply.

We used the file map to upload the data and used the @count column to get the counts.

Thanks for the immediate response.

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: Moreshwar on 07 Jun 2010 05:34:16 AM