https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743764#M92347 <P>Thank you!!</P> Wed, 03 Apr 2024 14:50:34 GMT ConfidenceOwl94 2024-04-03T14:50:34Z https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743451#M92302 <P>I have a table where some products were tested multiple times. I want to flag the last run by '1' in a new column.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ConfidenceOwl94_0-1712084019146.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/62989iEAA3BCC64A17A3A4/image-size/medium?v=v2&amp;px=400" role="button" title="ConfidenceOwl94_0-1712084019146.png" alt="ConfidenceOwl94_0-1712084019146.png" /></span></P><P>&nbsp;</P> Tue, 02 Apr 2024 18:54:28 GMT https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743451#M92302 ConfidenceOwl94 2024-04-02T18:54:28Z https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743482#M92305 <P>Here is one way to handle this......</P> <PRE><CODE class=" language-jsl">If( Col Max( Row(), :SN ) == Row(),<BR />1,<BR />0<BR />)</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="txnelson_0-1712087717293.png" style="width: 684px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/62990i25FE81CA5EFF85AE/image-dimensions/684x390?v=v2" width="684" height="390" role="button" title="txnelson_0-1712087717293.png" alt="txnelson_0-1712087717293.png" /></span></P> <P>&nbsp;</P> Tue, 02 Apr 2024 20:07:03 GMT https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743482#M92305 txnelson 2024-04-02T20:07:03Z https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743764#M92347 <P>Thank you!!</P> Wed, 03 Apr 2024 14:50:34 GMT https://community.jmp.com/t5/Discussions/How-to-add-final-test-check-column/m-p/743764#M92347 ConfidenceOwl94 2024-04-03T14:50:34Z