All possibilities mixer?

[Paul_Danyliuk]

Not totally sure what you exactly need. But you can always implement an action that will iterate however you need, explicitly. Like here:

What to do when CurrentValue is overloaded

That’s a know thing: There’s a workaround with storing the outer CurrentValue in a cell somewhere (e.g. same row dedicated column, or a helper table). E.g. here’s the way I’m iterating over Value Drivers, then each of their Metric Uplifts, then for each of those I insert six rows with a Sequence().FormulaMap(). Note how I store _Current Value Driver and _Current Metric Uplift into a cell before using it in a nested FormulaMap: [image] [image] (Fun fact: in retrospective, in my case none o…

E.g. if you need to make all combinations of 2 fruit, here’s the steps I’d take:

1. In your fruits table, make a column where you look up the remaining fruit to match this row with (e.g. thisTable.Filter(CurrentValue.RowID > thisRow.RowID), plus some custom conditional if you only need to match with some fruits and not all)
2. Implement the loop like in the link above. For each row store current row into a temp cell, and for each remaining fruit put a row with temp cell value and CurrentValue.