Hi guys,
Perhaps a peculiar task. My goal is to generate a dynamic array with random percentage weights. Couple of rules on that.
1. Generate 30 weights.
2. Each weight must be less than 10%
3. Sum of all weights must be 100%
4. For weights that are above 5%, sum of them must be not greater than 40%.
My thoughts were I could use random array function with max in there, but I don't know how to incorporate sum up to 100, and the 4th rule..
Example List attached. Any help will be greatly appreciated!!
Thank you!
Bookmarks