Hello All,

I am somewhat new to making conditional formulas in JMP and am having some difficulty with this one.

I will be collecting data at specific timepoints for multiple different samples. Each sample has a corresponding value for the initial (T=0) timepoint and I would like to have a column for the %difference at a given timepoint relative to T=0. The table will include multiple replicates of each sample (arranged in rows) and a dozen or so metrics (in columns). Here's the general idea of the table format:

I've tried to set the math to Match based on the Sample Designation column but am having difficulty with the conditional syntax for pointing a given row to its respective T=0 datum. I found the following searching for similar issues but was unable to modify the script to match my layout:

https://community.jmp.com/t5/Discussions/Divide-column-by-reference-point-with-conditions/m-p/432899...

Granted: I am less-than-a-novice with scripts...

I've included the jmp table as well.

Thanks in advance for your help.

Chris