Hi All,
I'm trying to build the formula in a table component, but it is not returning results.
left(slice(@A:A;),INDEXOF(slice(@A:A;),"?",1))
Alt+A on IndexOf part of the formula returns the expected number for each row.
But when IndexOf() is nested inside the Left() function it returns blank for all rows.
Is this a bug, or am I missing something really simple?
Thanks