Alteryx Designer Desktop Discussions

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

Sample selection based on percentage coverage of a group

Demetres
5 - Atom

Hi there,

 

I am having an issue of extracting a sample based on percentage coverage. What I am trying to achieve is to select a sample from each account shown below which will be equal or above the 10% of the total amount of the account.

 

AccountDoc. NumberAmountTotal of Account10 % of Account
60020400005100008405124,3512.649,491.264,95
600204000051000071921.750,0012.649,491.264,95
60020400005100007856885,0012.649,491.264,95
600204000051000085382.000,0012.649,491.264,95
600204000051000054451.749,6412.649,491.264,95
60020400005100005932-454,5012.649,491.264,95
600204000051000061416.195,0012.649,491.264,95
60020400005100007616400,0012.649,491.264,95
60020601001700002102285.446,58297.446,5829.744,66
6002060100170000816112.000,00297.446,5829.744,66
6002220000510000569271,38968,5696,86
6002220000510000569288,19968,5696,86
60022200001700000291-800,00968,5696,86
60022200001700006290119,97968,5696,86
60022200001700011652111,02968,5696,86
6002220000510000321755,43968,5696,86
6002220000510000320011,09968,5696,86
60022200005100003199163,56968,5696,86
600222000051000031994,17968,5696,86
600222000051000031995,54968,5696,86
60022200005100005707196,27968,5696,86
60022200001700002024139,01968,5696,86
600222000051000056859,27968,5696,86
600222000051000057054,28968,5696,86
6002220000170001126354,48968,5696,86
600222000020035163999,30968,5696,86
60022200005100006091407,34968,5696,86
6002220000170001324548,65968,5696,86
60022200005100008537142,75968,5696,86
6002220000510000853710,91968,5696,86
600222000051000085375,54968,5696,86
600222000051000085534,56968,5696,86
600222000051000085533,35968,5696,86
60022200002013076276,70968,5696,86
600222000017000016185,80968,5696,86

 

So, for the account 6002040000 which totals 12.649,49 I need a random sample of Doc. Numbers which will add up or above the 10% of total account amount (1.264,95).

 

I have tried a lot but unfortunately cannot get to the answer. I would appreciate a little bit of help.

2 REPLIES 2
Raj_Singh1
9 - Comet

hi @Demetres 

 

please see attached. you may or may not require that formula in red box as that is for me to convert European standards number to British standards by replace comma , and decimal . position.

 

let me know if you have any question.

 

thanks

Screenshot 2020-11-12 10%.png

Demetres
5 - Atom

Thank you Raj_Singh for your prompt reply! Your solution was easy to understand and it helped me solve my problem!

Labels