Last column,Col Value(NCol()-1)
I have data tables where the number of columns vary, but the last column in each table holds information such as "PASS" and "FAIL" where I want to create a new column in each table where if it is PASS then replace with numeric 1, and Fail numeric 0 with an IF statement. I tried New column with formula Col Value(NCol()-1) and it does not work. If I replace with a hard coded column value e.g., Co...