community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Generating a RANDINT that is less than an existing variable - in this case a median value

Atom

Hello all,

 

I am working to build a formula that generates a RANDOM INTEGER > 1 but less than the MEDIAN VALUE OF A VARIABLE (the new value would have a range of 1 to the MEDIAN VALUE which changes depending on the country- all Median values are >1) – any thoughts as to how to write this?

 

Example below:

IF ([D10b_2_Savings_account_s_total_curent_balance__all_savings]>[Median_D10b_2_Savings_account_s_total_curent_balance__all_savings]) THEN

 

RAND (1,[Median_D10b_2_Savings_account_s_total_curent_balance__all_savings])

 

ELSE [D10b_2_Savings_account_s_total_curent_balance__all_savings]

 

ENDIF

 

Hard to give concrete advice without a sample of the data. 

 

But I would use a summarize tool to produce the medians and then join tool to join back to the original data by country

 

You can then use the value in a Rand function as you have for each row.

 

 Happy to help further but would be useful if you could fake some data for us to advise on.

Labels