unique count

[rivet]

in a list of numbers (found set), is there a way to count how many are unique?

[Inky Phil]

Hi rivet

presuming that the list of numbers is one number per record you could cretae a global to hold your count of uniques, self relate the file on the number field and then loop through the records using this relationship comparing each record with the next and the previous. If the number does not equal the next or previous then it is unique and you can add 1 to your unique counting global.

There may be a much cleverer and simpler way than that but with my limited experience that is the way I would approach it

HTH

Phil

[aaa]

Create one value list which based on your number field.

Then Unique_Count=Wordcount(ValuelistItems(...........))

[rivet]

that is good but it is for the complete table, I would like it to happen with a found set.

[aaa]

Yes rivet! You are right.

[-Queue-]

If you put the id for all found records in a global and relate it to your id field, then you can create a value list based on the found set.

[aaa]

Helo Queue! How i can put id for all found records in global field? By script?

[LaRetta]

Script to capture IDs of a found set into a global (text) called gIDs:

Set Field [ gIDs; "" ]

Go to Record/Request/Page [ First ]

Loop

Set Field [ gIDs; If(IsEmpty(gIDs); ID; gIDs &

[-Queue-]

LaRetta, you can do away with the If by using

gIDs & ID &

[LaRetta]

Hi JT,

Your idea saves testing ... it just sets! And you know how I feel about wanting optimum! Sweet!

It's sure good to have you back!!

LaRetta