Hi folks,
I created a report to pull a list of records from a user specified date for managers to use to perform staff audits on claim files. From that list of records, the user only wants to see a randomized subset.

Anyone have ideas on how best to accomplish randomization?

NOTE: I am a non-technical business analyst and only have access to InfoAssist, not any of the technical programming tools.

This message has been edited. Last edited by: Tamra,

Probably the simplest way to do this is to add a COMPUTE - Data tab on Ribbon -> Summary(Compute) - with the following:

Field: RNDM (or anything else you like)
Format: 12.6
Expression: RDUNIF(RNDM)

Then select the new field and sort and optionally put a limit.

We use this to show a random 10 entries for audit purposes

Cheers

Stu

Thanks for your example Steve. I learned that it is important to have plenty of decimal places to get a really broad result each time the query is run.

I appreciate your support!

Sorry Stu, I meant to thank YOU!