Hi there @Christiaan_Huizer
!
I’m no FormulaMap() expert (still learning about this versatile formula
), and I haven’t been using Slice() a lot but I just think the Nth() are not necessary in your Slice() formula.
As when using Slice(), you’re already indicating a position where it should start and end, making Nth() useless (I think
). I was still able to make the formula work using Slice() + Nth() (see the field Failure) but I’m pretty sure some part are redundant (feels like it, at least
)
Anyway, I did play a little bit with your doc (after copying it
) and ended up with this formula :
Sequence(1,thisRow.thelist.Count()-1).FormulaMap(thisRow.thelist.Slice(CurrentValue,CurrentValue+1))
Which seems to work
.
I did try another approach (see List() 1 + 2 ) as your post made me think about something I asked some time ago
and kind of took as an inspiration the answer Paul gave me
.