COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Zimbo_African_1980 on 17 Dec 2014 01:09:49 PM

Title: Count function
Post by: Zimbo_African_1980 on 17 Dec 2014 01:09:49 PM
Good day folks,
I have a field on my report page that shows either '0' or '1'.
I would like to add a count on the filed but would only want to count the number of times the '1' appears.
I believe this is something to do with conditional formatting.

Can someone please help and explain this to me

Thank you

Ruzvmun
Title: Re: Count function
Post by: qvixote on 17 Dec 2014 01:14:48 PM
Thinking mathematically, if you use a sum it will work, because the sum only will "count" cells with 1.