Free Trial

Alteryx Designer Desktop Discussions

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

How to select samples from running total

SahadhKuruniyan
8 - Asteroid

I am preparing an Alteryx solution to select 85% of total balance of entities. Please see the table below:

 

AccountEntityValuaeRunnig totalTotal A/C balance%
CashA858530028
CashB7616130054
CashC5521630072
CashD3525130084
CashE1826930090
CashF1628530095
CashG15300300100

 

I used the formula ---  IF [ABS Percentage %] < 86 then "Inscope" else "Out of scope" ENDIF

I problem here is the alteryx now only pick value below 86.

 

But in this table to cover 85 % I have to take till entity E. 

there are more accounts like bank, gold, stocks etc..

 

Is there any other way to do this

1 REPLY 1
SahadhKuruniyan
8 - Asteroid

For the Bank I have to select entity A and B to cover 85%

BankA45045060075
BankB12557560096
BankC25600600100
BankD0600600100
BankE0600600100
BankF0600600100
BankG0600600100

Can anyone please help me to create a solution for this

Labels
Top Solution Authors