Formula to toggle value (1 or 0) in new column based on change by row in existing column
I have a question on creating a formula to do something in JSL that I do very easily in Excel. If I were to have Column A and I want to generate Column B, I would put a zero in B1 then add the formula: =IF(A2<>A1,IF(B1=0,1,0),B1)into B2 then copy down the column. Is there a formula to do that in JMP? I have tried Lag() but it doesn't give me the results I'm looking for.