ValueCount - converse counting?
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