save a table value and use it in a formula

JulieSAppel

Hi,

I need to grab a single value (baseline value) from a data table so I can use it in a formula to calculate a relative values.

 

I tried to use the the get values where functionality and save it as a variable. I don´t get an error but I don´t get an output either. What am I doing wrong?

 

col_dark = column(data table("splitsummary2"), "AUC dark phase absolute (ml/kg)") << Get Values Where(Column("Compound") == "Vehicle0mg/kg")

 

Br Julie

 

 

splitsummary2.jmp

txnelson

I have never heard of a function called "Get Values Where".  What I think you are refering to is "Get Rows Where()".  Below is a reworking of your code to what I think you want......

col_dark = :Name( "AUC dark phase absolute (ml/kg)" )[Data Table( "splitsummary2" ) <<
Get rows Where( :Compound == "Vehicle0mg/kg" )]