BEx Query Designer - Generate Random Number

[audrey_noordam]

Hi everyone,

Has anyone created a formula in BEx Query that produces a random number so I can use the Top % filter to create a random list on a report?

If so, can you please send me the formula you used?

Thanks, Audrey

[audrey_noordam]

I'm looking to replicate the Excel functionality "Randomiz List" in a BEx Query.

Any suggestions would be appreciated.

Thanks, Audrey