3 Replies Latest reply on Jun 7, 2010 1:58 AM by aikiko

    ValueCount - converse counting?

    aikiko

      Title

      ValueCount - converse counting?

      Post

      Dear All,

       

      A simple question if I may:

       

      Is there a way to count the number of values in a text field using the ValueCount function that is the converse of the field that is initially selected?

       

      E.g. My value list (Fruit) includes Apples, Bananas, Oranges, Pears

       

      My calc to count the number of 'Apples' in my database is:

       

      ValueCount ( FilterValues ( List (Fruit) ; "Apples" ) )

       

      but what is the ValueCount syntax to count all the values which are NOT Apples i.e. the Bananas, Oranges, Pears?

       

      Along the lines of: ValueCount ( FilterValues ( List (Fruit) ; NOT "Apples" ) )

       

      Thanks in advance,

       

      Aikiko

      FMP 10(Adv), OXS10.6