2 Replies Latest reply on Jun 1, 2010 5:38 PM by jd3

    Creating a Count from a Field that uses a Value List

    jd3

      Title

      Creating a Count from a Field that uses a Value List

      Post

      Wow, I am a very new user to FM and Database's in general.

       

      I have a field called "Sales Type" and have only 3 choices from a value list, (New, Used, Other). I want to see a count by each of these and can't figure out how to do it.... Any help will be appreciated. My records are getting longer by the week and I have interest in knowing the number of New, Used and Other counts for statistics etc...

        • 1. Re: Creating a Count from a Field that uses a Value List
          philmodjunk

          Here's how to do it for one entry in your value list. If you understand how it works, you'll be able to repeat the process for the others.

           

          First, define a calculation field, cNewFlag,  that will extract one of the three possible values from your value list formatted field.

           

          FilterValues ( Sales Type ; "New" )

           

          set this calculation field to "text" as its return type.

          Now this field will show "New" for any record where New was selected in the Sales Type field.

           

          Define a summary filed, sNewCount as the Count of cNewFlag.

           

          This summary field will correctly return the number of records where "new" was selected as long as all such records are in your found set.

          • 2. Re: Creating a Count from a Field that uses a Value List
            jd3

            Many thanks! It is working as you described.....