Slicing the RowIndex fails because of sub-list

Hi there @Christiaan_Huizer :blush: !

I’m no FormulaMap() expert (still learning about this versatile formula :innocent: ), 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 :innocent: ). 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 :sweat_smile: )

Anyway, I did play a little bit with your doc (after copying it :wink: ) and ended up with this formula :

Sequence(1,thisRow.thelist.Count()-1).FormulaMap(thisRow.thelist.Slice(CurrentValue,CurrentValue+1))

Which seems to work :blush: .

I did try another approach (see List() 1 + 2 ) as your post made me think about something I asked some time ago :blush: and kind of took as an inspiration the answer Paul gave me :blush: .

2 Likes