6 Replies Latest reply on Jan 10, 2015 6:48 PM by GraysonSmith

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

    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?