AnsweredAssumed Answered

ValueCount - converse counting?

Question asked by aikiko on Jun 7, 2010
Latest reply on Jun 7, 2010 by 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


 

 

 

 

 

 

Outcomes