Counting yielding incorrect answer ?
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
thanks in advance for your help
If I got that result, I would suspect that one of my entries that looks like a duplicate isn't--perhaps there's an extra space character or something in the field so that the value is actually unique instead of a duplicate.