In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

gnans19
11 - Bolide

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

––––––––––

 

11 REPLIES 11
paulfound
11 - Bolide

Had a break and come back to it, think this fills the criteria. 

 

Enjoyed the challenge.

 

PaulFound_0-1600268302191.png

bit messy and could do with going into macro, but ticks all the boxes I think

 

gnans19
11 - Bolide

Thank you @paulfound This is amazing. I thought this is an optimization problem and needs LP solution. 

Labels
Top Solution Authors