March 29, 200619 yr I would like to be able to find a count of the unique values of a particular field in a found set, e.g. find how many different last names there are in a list of people. I've dabled with calculations triggered by scripts, summary fields based on the field in question, but the only way I've gotten it to (sort of) work is to create a value list from the field, then do ValueCount ( ValueListItems ( "DatabaseName" ; "FieldValueList" ) ) however this seems to work only for the entire database, not just the found set. This topic and this one cover this a bit, but its not clear if they've gotten it to work, I don't completely understand their solution, and they seem to be doing something more complicated. This seems like it should be a basic function for a report- to summarize unique values, and I can get a list, but I just want a simple count at the click of a button.
March 30, 200619 yr See comment's description from the second thread: http://fmforums.com/forum/showpost.php?post/197350/ Because it involves the getsummary() function, you do have to sort the found set to get the result.
Create an account or sign in to comment