Sum all possible combinations then match against a value

Question

Hi

I hope the following make sense.

I hope the following makes sense. So I want to sum all the possible combinations the amount below, Per id then type.

idTypeAmount1a101b201c301d402a302b102c502d70

So something like:-

idComboSum amount Amount1a+b+c+d1001a+b+c601a+b301a101a+d501b+c50

An so on...

Then if the below matches with in 1 either way then return the combo’s that match

idAmount150.502120.49

Gunjan_Chhabria · Answer

Additionally, is there a way to join row 1 and row 3 as well i.e., we are currently having a row for

1

1,2

1,2,3

But is there a possibility to joing 1,3

Gunjan_Chhabria · Answer

Hello, that does help I made the max limit as 20k, but now the macro takes about 3+ hours to run - is there a way to reduce time?

abacon · Answer

If it is an iterative macro, you can set the max iterations. Open up the macro, go to Interface Designer, under the settings icon. You will see max iterations.

Bacon