We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start 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