5 Replies Latest reply on Jun 11, 2010 3:22 AM by comment_1

    ValueCount - combine more than 1 ValueCount calc?

    aikiko

      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