AnsweredAssumed Answered

ValueCount - combine more than 1 ValueCount calc?

Question asked by aikiko on Jun 10, 2010
Latest reply on Jun 11, 2010 by comment_1

Title

ValueCount - combine more than 1 ValueCount calc?

Post

Hi

 

Is it possible to create a calc field that combines more than one ValueCount calc? 

 

For example:

 

If I want to know how many Granny Smith apples are green, should I aim for something like this (incidentally this doesn't work, but it just returns a number 1 in the calc field)?

 

ValueCount ( FilterValues ( List (Apples); "Granny Smith") ) and ValueCount ( FilterValues ( List (Colour); "Green") )

 

and, if f I want to know how many Granny Smith apples are purple:

 

ValueCount ( FilterValues ( List (Apples); "Granny Smith") ) and ValueCount ( FilterValues ( List (Colour); "Purple") )

 

Thanks in advance for any assistance that can be provided

 

Aikiko

FMP10Adv. OSX10.6

 

 

 

 

 

Outcomes