4 Replies Latest reply: Jun 3, 2011 8:54 AM by Erich Shino RSS

    TextCount vs. Count vs. Count (Distinct)

    Sam Chambers

      Attached is the table I'm working with.    Notice that AccountNumber A817998 shows up twice, and the net ChargeAmount = zero.

       

      QV is doing something I don't understand.  Using various expressions to count the   number of items in he table, I get different results:

       

      • TextCount (Unit) = 14.  This is also correct, if account A817998 is ignored.
      • Count (Unit) = 14.  This is also correct, if account A817998 is ignored.
      • Count (Distinct AccountNumber) = 15.  There are indeed 15 accounts in the table, but this expression considers account A817998.
      • Count (ChargeAmount) = 16.  There are a total of 16 entries in the table, including both entries for account A817998.

       

      What I don't understand is why TextCount (Unit) and Count (Unit) ignore account A817998.  That is exactly what I'm trying to do , but I don't understand why QV is ignoring that account.

       

      Any ideas?