I followed the example calculation of the FM Knowledge Base "Counting the Number of Unique Values in a Field" , and I am not getting the right result.
The instructional SQL statement example says ExecuteSQL ("SELECT COUNT (DISTINCT LocationField) FROM ContactTable" ; "" ; "").
Based on the above example this is my calculation. ExecuteSQL ( "SELECT COUNT(DISTINCT MR #)FROM Radiology Performed Exam for TAT";"";"")
But I am not getting any result, except the ? mark. I formated the field for zero decimal place, and my field is long enough to display 10 digits.
Do I need to put anything within the two double quotes at the end of my SQL statment?
Appreciate if anyone can be helpful for me.........