AnsweredAssumed Answered

Unique Value Function

Question asked by AreliLopez on Aug 19, 2011
Latest reply on Aug 19, 2011 by AreliLopez


Unique Value Function


I am trying to find the unique values of a field called Part Number. In this field, there are many part numbers that repeat, so I want to output the unique part numbers found in Part Number field. Then I want to find the number of times each unique part number repeats in the field. I have looked online and found the UniqueValues(values) function that does the first thing I am looking for. However I don't find the function in the "Specify Calculation" there a way to implement this function? I am using FileMaker Pro 11.