(tldr:) Goal: create a button/formula that outputs a random single result based on a table with corresponding pool of list and its equivalent column of probability weight of random chance getting picked (either by percentage or number)
I just want to generate a random single entry from a list (accounting by percentage or by number) every time a button is click. Prefer direct to page formula. But if it cannot be, one can use a control element or intermediary table.
(This embedded document below, doesnt account the weight, and formula is kinda bug or im wrong.)
- Making use of RandomItem() and RandomInteger() might be handy too.
- There might be a need of two formulas, for list with percentile weight, and for list with numerical weight.