Formula Editor: help with using Subscript function dynamically

sowiakg — Wed, 09 Sep 2026 21:54:41 GMT

Hi all,

I'm trying to compare across rows in my data table in a generalizable manner. To do this, I'd like to create a formula column that finds and returns a value from a specific row with certain traits.

In this example screenshot, I would like the "Control Result" to be a formula column that returns the "Control" row with a matching "Donor" field, and return the corresponding "Result" score. I would like to use Formula Editor for this, and the most intuitive way I can think to return data from another row is to use Subscript.

However, I am not sure how to properly create the logic for "i = (lowest) row with matching Group and Condition='Control'". What formula block (or combination thereof) can be used to return "i = the row number that matches X conditions"? Might there also be some byVar trick I should use here?

As an aside: I know Match is another option, however it seems to require writing out the "Control" values in the formula block itself (or bespoke Subscript calls) for each Group. I am trying to replicate this workflow across a much larger dataset and would prefer to minimize hardcoded values. I also work with a lot of non-coder collaborators and would like to avoid JSL; and only need to swap out the Condition and Result fields as necessary using the Formula Editor.

Thank you!

Re: Formula Editor: help with using Subscript function dynamically

txnelson — Thu, 10 Sep 2026 02:48:49 GMT

Here is the formula I came up with:

Col Cumulative Sum( If( :Condition == "Control", :Result ), :Group )

Re: Formula Editor: help with using Subscript function dynamically

jthi — Thu, 10 Sep 2026 04:25:17 GMT

Col At() was added in JMP19 and it allows you to look for values of specific indexes within groups. So you can use that if Control rows are always before Tests (Column 3 is Result and Column 1 is Group)

Col At(:Column 3, 1, :Column 1)

Scripting Index has more examples.

topic Re: Formula Editor: help with using Subscript function dynamically in Discussions

Formula Editor: help with using Subscript function dynamically

Re: Formula Editor: help with using Subscript function dynamically

Re: Formula Editor: help with using Subscript function dynamically