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
Solved! Go to Solution.
Many thanks - this worked!