Using specific row values for use in a formula

[#1]

Hey there,

I'm sure this has been covered in the past, but I had trouble finding something that matched.  In a new column I would like to calculate Average release for condition 9 as compared to the same time points in the control.

Something like this logic:

When Condition # =! "Control",

Divide average release by the corresponing average release (by Time Point) in the Control.

Eventually I would like to perform F2 dissolution comparison calculations in a column but need to start with calling a specific row first.

[#2]

@DBiber, 
   I am presuming you are looking for something like this. But I am not sure I follow your question - so let me know if this is not what you want. 

dt = Current Data Table(); 

SR = dt << Select Where(:Condition # == "9") << Get Selected Rows; 

Show(SR); // Print selected rows to log 

Denominator = Mean(:Time Point[SR]); // Correct as needed for your formula 

dt << Clear Select; 

NewCol = (dt:Average Release << Get Values)/Denominator; 

dt << New Column("Test",Numeric,Continuous,<< Set Values(NewCol)); 

[#3 · Accepted solution]

Try this formula

If( :Condition # == "Control",
	.,
	:Average Release / Col Mean( If( :Condition # == "Control", :Average Release, . ), :Time Point )
)