Cognos 11
I am trying to sample 50% of the records in my list report randomly, i.e. if my list returns 100 records then I would like to display 50 random records. I have tried using combinations of Rand, Running-Count, and Newid, and I've yet to get one to work correctly. I am able to pull 50% of the records, however the same records display every time I run the report. I had my list sorted on NewId, and another time on the Rand column, however neither seemed to enable me to pull random results.
Do you have any thoughts? Thanks!