Combination

[jonickmabini]

Hi I want to create a workflow that will identify the combination from the given sum of 26,191.83.

Breakdown:

Amount	Customer Reference
3,369.46	cr
3,069.10	cr
1,578.46	CS
5,641.30	CS
2,694.51	CS
2,901.52	ChaseCS
1,180.19	DC
3,365.54	chaseDC
2,033.88	DC
3,559.17	ChaseEC
3,378.31	EC
778.98	EC
778.98	EC
3,831.72	EC
2,007.75	EC
2,054.31	JL
1,716.78	CHASEJL
9,702.38	MAWHORTER
3,828.51	MAWHORTER
3,579.03	PP
61,049.88	Total

[Hayden_Arnold]

Assuming you're looking for different combinations of the given values that sum to 26,191.83, and it can be any combination of 2, 3, 4+ different values, there are frankly too many combinations to test via brute force - a similar question was posed here, where some code-based optimizations were applied in R: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Finding-combinations-of-number...

Let me know if this isn't what you're shooting for.

[PhilipMannering]

@jonickmabini 

I've found your (or at least, one such) combination.