4 Replies Latest reply: Jun 3, 2011 8:54 AM by erich shiino 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?