JSL Compare value in row to the next row.
Hello,I am trying to use "FOR" and "IF" to create a condition column. I have this table and I want the "Con" column to indicate if the age in the row after is lower then the current row. if yes "1" if not "0"NameAgeConDavid230Bari261James120Lora140 This is what I have: (doesn't work)dt<< New Column( "Con", Formula( For( i = 1,i <= N Row( dt ), i++, If(:Age[i] >= :Age[i+1] , "0", "1", ))));
Your he...