AnsweredAssumed Answered

How to count discrete values from separate fields?

Question asked by WF7A on Aug 13, 2014
Latest reply on Aug 13, 2014 by WF7A

Title

How to count discrete values from separate fields?

Post

     Greets, all:

     I'm short of coffee this morning so maybe that's why I can't find/figure out an answer to a problem I need to solve: I need to count the number of discrete values from separate fields; I've found info on something like it on the Web for when you want to count discrete values in _one_ field but not from _many_ fields.

     Example: You have five fields, each one assigned a numerical value:

      

     DB1 = 1

     DB2 = 3

     DB3 = 2

     DB4 = 3

     DB5 = 1

      

     So, the result I'm looking for should look like this:

     Count of 1s: 2

     Count of 2s: 1

     Count of 3s: 2

     Count of 4s: 0

     ...etc.

      

     Suggestions and help will be greatly appreciated. Thanks!

Outcomes