Random Value Generation

Is there a way to use rand(), to randomly select user from a group?

Yes. You'll need to do this steps:

1. get a list of all the Users you want to randomly select - let's call this local!users
2. derive the number of these - you can use fn!count() over the list from step 1
3. generate a random number using fn!rand()
4. multiply the count from step 2 by the value in step 3 - if the result is 0 - because rand() can return 0 - then you'll need to try again - let's call this local!randUserIndex - you'll need to coerce the result into an integer - use fn!integer(fn!fixed()) -  this value represents an random index into your list of users
5. you can then simply return a user: local!users[local!randUserIndex]

Hope this helps

S>

Yes. You'll need to do this steps:

1. get a list of all the Users you want to randomly select - let's call this local!users
2. derive the number of these - you can use fn!count() over the list from step 1
3. generate a random number using fn!rand()
4. multiply the count from step 2 by the value in step 3 - if the result is 0 - because rand() can return 0 - then you'll need to try again - let's call this local!randUserIndex - you'll need to coerce the result into an integer - use fn!integer(fn!fixed()) -  this value represents an random index into your list of users
5. you can then simply return a user: local!users[local!randUserIndex]

Hope this helps

S>

Thank you so much..It helped. I changed it to single line: index(ri!user,tointeger(fn!fixed(count(ri!user)*fn!rand()))+1,{})