cancel
Showing results for
Did you mean:
Frequent Visitor

## Assign Random Number For Each Distinct Item

Hello,

I have a table with document numbers and \$ amounts. Some document numbers have multiple amounts, so those numbers repeat within the table.
I'd like to assign random numbers to each distinct document number. Is there a way to do a FOREACH() type formula that will assign the RAND() function to each distinct value in my document number column?

Example Output:

 Rand() Doc Number \$ Amount .992 1 100 .992 1 89 .876 2 2000 .653 3 41 .653 3 200
1 ACCEPTED SOLUTION
Frequent Visitor

I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution.

2 REPLIES 2
Frequent Visitor

I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution.

Frequent Visitor

Bump

Announcements