gespolin

How can I find the number of records with specific values?

Discussion created by gespolin on Aug 4, 2016
Latest reply on Oct 27, 2016 by fmpdude

I obviously don't understand how the Count function works. It's said to return "the number of valid, non-blank values in field", but I cant't make it do just that. Here is a simple example:

Let's say I have registered observations of two kinds of birds (A and B) in two different countries with a number of counties in each country.  I then want a report sorted by country and county, showing the number of observations of A and B respectively.

 

Country 1

     County 1   

          Count of A     Count of B

     County 2  

          Count of A     Count of B

     County n   

          Count of A     Count of B

 

Country 2

     County 1a   

          Count of A     Count of B

     County 2a

          Count of A     Count of B

     County m   

          Count of A     Count of B

 

Whatever I do and however I arrange my layout parts, the Count function returns the number "1" for every entry. I would appreciate very much if someone can expplain what I need to do.  —  Sincerely and hopefully, gespolin

Outcomes