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.
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));