5 Replies Latest reply: Mar 31, 2014 9:45 AM by Colin Devon RSS

    Issue with GetSelectedCount() when using IncludeExcluded parameter

      I thought using GetSelectedCount(FieldName, True()) was supposed to return the total number of distinct values in a field?

       

      It works for GetSelectedCount(FieldName) where the selected values are returned but I would like to get the total number of values in the field.

      For

       

      LOAD

       

       

       

      * INLINE [
      F1, F2, F3
      01/01/2012, 01/01/2013, 1
      01/01/2012, 02/01/2013, 2
      01/01/2012, 03/01/2013, 3
      02/01/2012, 01/02/2013, 4
      02/01/2012, 02/02/2013, 5
      02/01/2012, 03/02/2013, 6
      ]

      ;

       

       

       

      I'd expect GetSelectedCount(F1, True()) to return 2 at all times (as only 2 unique values) but this isn't happening.

       

      Is the only way (?) to do the following instead?

       

      Count (Distinct All F1)