AnsweredAssumed Answered

Counting yielding incorrect answer ?

Question asked by BrianBrouillette on Feb 13, 2014
Latest reply on Feb 13, 2014 by philmodjunk

Title

Counting yielding incorrect answer ?

Post

     Hi

        I am trying to count unique values in a field using the ExecuteSQL command  - the command "works" but yields the incorrect answer  (on a list of 19 records, there are 6 unique names and my query shows 7 --hence my post....

      

        THe query I am using is ExecuteSQL ("SELECT COUNT (DISTINCT\"Customer\"FROM \RE Plan 2.0 Converted|"";"";"")

         The field Customer is set to Text  and "always validate , custom values list 

      

     any ideas?

     thanks in advance for your help

Outcomes