1 Reply Latest reply on Feb 13, 2014 11:11 AM by philmodjunk

    Counting yielding incorrect answer ?

    BrianBrouillette

      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