I have a group of different products having different quantities and want to bundle them in to groups summing up to 10 as close as possible. For example, below I have 11 products and I want to break them in to groups that would have the sum of the quantity equal to or closest to 10. Has anyone tried something like this in Anaplan?
Product | Quantity |
|---|
Product 1: | 2.15 |
Product 2: | 1.5 |
Product 3: | 3.2 |
Product 4: | 2 |
Product 5: | 0.4 |
Product 6: | 3 |
Product 7: | 1.8 |
Product 8: | 2.35 |
Product 9: | 2.75 |
Product 10: | 0.75 |
Product 11: | 0.1 |
So an output for the above are 2 groups with the following groupings:
Group 1: | |
|---|
Product 2: | 1.5 |
Product 4: | 2 |
Product 6: | 3 |
Product 9: | 2.75 |
Product 10: | 0.75 |
Total Group 1: | 10 |
| |
Group 2: | |
Product 3: | 3.2 |
Product 7: | 1.8 |
Product 8: | 2.35 |
Product 1: | 2.15 |
Product 5: | 0.4 |
Product 11: | 0.1 |
Total Group 2: | 10 |
| |
