Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATook me a bit longer than I expected and I'm sure there should be an easier way but I seemed to have followed the solution. I realise that it probably requires some iterative macro if you want to optimise it but I'm not that advanced (yet). Still good fun.
It's a shame that some tools (e.g. Multi-field formula, multi-row formula, Generate rows) that use formulas / expressions don't have the same intellisense as the main formula tool as would improve builds.
Happy beginning of the week 🙂
PFA my solution.
Data analysis is derived via multi field tool expression, which is always a great learning. It covers statistical permutation and combination method to fulfill the orders however, the task is to fulfill only those orders that are highest in quantity. It is a brilliant exercise as this can be a very practical use case scenario.
Thanks to SMEs.
Regards,
Pratik
My solution: