6 Replies Latest reply on Feb 15, 2013 4:21 PM by Frank Galeana

    Marks does not allow to Count(distinct) only allows sum

    Frank Galeana

      Please see attachment.  I'm trying to get a count of distinct records for a field called Athena Key.  Wen I bring the field to the Marks/Text section it produces the sum of the keys (becuase it's a number).  So it sums up all the numbers.  But what I really want is a count of how many unique keys this field contains.  When I switch count (distinct) it gives me an error. I tried this with a number and a character field but it doesn't work.