AnsweredAssumed Answered

ValueCount - converse counting?

Question asked by aikiko on Jun 7, 2010
Latest reply on Jun 7, 2010 by aikiko


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