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

    ValueCount - converse counting?



      ValueCount - converse counting?


      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,



      FMP 10(Adv), OXS10.6