If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Count function

Started by Zimbo_African_1980, 17 Dec 2014 01:09:49 PM

Previous topic - Next topic

Zimbo_African_1980

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

qvixote

Thinking mathematically, if you use a sum it will work, because the sum only will "count" cells with 1.