AnsweredAssumed Answered

Finding the amount of times certain field option is selected over multiple records.

Question asked by GraysonSmith on Jan 9, 2015
Latest reply on Jan 10, 2015 by GraysonSmith

Title

Finding the amount of times certain field option is selected over multiple records.

Post

Im having a little trouble creating a counter for the following scenario:

Say you have Table 1. Table 1 only has 1 field named Field 1. Field 1 is a drop down list field with the options "A","B", & "C". The following data is from the records of Table 1 using the field, Field 1:

Record 1: Table 1::Field 1 = "A"

Record 2: Table 1::Field 1 = "A"

Record 3: Table 1::Field 1 = "B"

Record 4: Table 1::Field 1 = "C"

What I want is a counter that searches across the records for table one and finds how many times a certain option is selected. For example, I want to know how many times "A" was selected in Field 1 and it would return "2".

 

I tried using a calculation field defined as: PatternCount(Field 1 ; "A") , However this isn't working to return the amount of times "A" is selected for that field. Ideas?
 

Outcomes