How do I generate 10 unique random numbers between 1 and 100 that sum up to 100?

[gnans19]

How do I generate 10 unique random numbers between 1 and 100 that sum up to 100?

Example:

11
23
3
5
18
6
7
8
9
10

–––––––––

            100

––––––––––

[atcodedog05]

This is a great challenge.

Let me see how this can be solved.

[paulfound]

Hi @gnans19 

This is what I came up with:

basically it calls and number between 0-100 and then sums up and takes the % of the total to give a split between 0 - 100.

Let me know if this works.

[nitinsnow]

I hope this helps !!

Thanks

Nitin

[atcodedog05]

Hi @paulfound and @nitinsnow  ,

Great solutions. I did a couple of runs. 

It seems like it isnt giving unique numbers each time. And is there a way to make it that it doesnt give me 0 as a number.

Cheers and Happy Analyzing : )

[nitinsnow]

Hi @gnans19 @atcodedog05 

The workflow generates random numbers at each run (with the addition of 100), and now the numbers are always greater than 0.

I hope this helps, if yes, please accept it as a solution.

Thanks

Nitin

[atcodedog05]

Hi @nitinsnow ,

As per the requirement. The number needs to be unique. Its still not unique.

[paulfound]

Hi @atcodedog05 , @gnans19 , @nitinsnow 

Getting a bit messy now, but updated to get 10 unique numbers that adds up to 100.

[paulfound]

Just realised there is a chance that these won't be unique.

[nitinsnow]

@atcodedog05 We are generating a random number here, At each run, the number change, so the column might have few duplicate values for a specific run.