I am preparing an Alteryx solution to select 85% of total balance of entities. Please see the table below:
Account | Entity | Valuae | Runnig total | Total A/C balance | % |
Cash | A | 85 | 85 | 300 | 28 |
Cash | B | 76 | 161 | 300 | 54 |
Cash | C | 55 | 216 | 300 | 72 |
Cash | D | 35 | 251 | 300 | 84 |
Cash | E | 18 | 269 | 300 | 90 |
Cash | F | 16 | 285 | 300 | 95 |
Cash | G | 15 | 300 | 300 | 100 |
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
For the Bank I have to select entity A and B to cover 85%
Bank | A | 450 | 450 | 600 | 75 |
Bank | B | 125 | 575 | 600 | 96 |
Bank | C | 25 | 600 | 600 | 100 |
Bank | D | 0 | 600 | 600 | 100 |
Bank | E | 0 | 600 | 600 | 100 |
Bank | F | 0 | 600 | 600 | 100 |
Bank | G | 0 | 600 | 600 | 100 |
Can anyone please help me to create a solution for this