What to do when CurrentValue is overloaded

[Paul_Danyliuk]

That’s a know thing:

Outer CurrentValue access

Hello there! I have a table with one unique column and one non-unique. I want to print a list of all dirrefent values in second column with numbers of items match these values. I think here in my screenshot second CurrentValue should be white as first, and should refer to FormulaMap context, not to CountIf. How can I do this? [2019-05-14_02-30-05]

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:

(Fun fact: in retrospective, in my case none of this temporary cell saving was needed I could rewrite the formula without it )

---

However, in your case CurrentValue is in fact a row from Habits to condition with. It’s a bug with formula editor that incorrectly treats it as if from Messages 2 table. See:

Update: Formula Improvements - Type understanding

@Jason_Tamulonis It still doesn’t resolve CurrentValue in .FormulaMap(AddRow()) context properly. E.g. here the suggestions should be from Source table, not from Table 2 [image] Proof that CurrentValue in this context is actually a row from Source table is that this works: [image]