find first element with condition in a column
Hi, I have a data with 2 columns: group and score, and I want to calculate the 3rd column called first, which returns the "first score by group that is not 10000000000. so in this sample data, group a = 0, group b =53. and since group c only contains 10000000000, nothing shows up for it.Could someone help me with a jmp formula for this column but not jsl? Thank you so much!groupscorefirsta10000000...