### Title

Count of Unique Values

### Post

I have a field with varying integer values. Need to

know how many different number values in the data.

As example, could have many records with value 2,

many records with value of 4, many records with value of 8.

Need a function or functions that can tell me there are

just 3 different numbers (2, 4 and 8).

Thanks for your help.

CountryBoy1

There is a way to do this with summary fields that has been posted to the forum previously.

Define a count of summary field that counts your number field, I'll call it sGroupCount.

Define a calculation field: cFraction: 1/Get Summary (sGroupCount ; YourNumberFIeld )

Define a second summary field sUniqueCount as the the Sum of cFraction.

This works on the found set as long as your sort your records by YourNumberField.