Hi Expert,
How can I add a new column (D) that able to add count row IF "CompareSeqVsAlarmDP" is 1 in sequence using JSL?
I can reproduce this condition in Excel using IF statement : IF((C27=0),0,(C27+D26)).
But still unsuccessful to convert the IF condition in JMP.
I think something wrong with my IF statement. My JSL statement is as below:
dt1:New Column << Set Formula(If(:"CompareSeqVsAlarmDP=z"n == ., 0, :"CompareSeqVsAlarmDP=z"n + (:New Column - 1)))
![WebDesignesCrow_0-1701944140251.png WebDesignesCrow_0-1701944140251.png](https://community.jmp.com/t5/image/serverpage/image-id/59407iB0891AE4E24F1D76/image-size/medium?v=v2&px=400)
![WebDesignesCrow_1-1701945079338.png WebDesignesCrow_1-1701945079338.png](https://community.jmp.com/t5/image/serverpage/image-id/59410iD2BC67EAE767610F/image-size/medium?v=v2&px=400)
thank you in advance!