topic Re: Using specific row values for use in a formula in Discussions

Using specific row values for use in a formula

DBiber — Tue, 12 Jun 2018 19:27:14 GMT

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.

Re: Using specific row values for use in a formula

uday_guntupalli — Tue, 12 Jun 2018 19:52:16 GMT

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

Re: Using specific row values for use in a formula

txnelson — Tue, 12 Jun 2018 20:24:25 GMT

Try this formula

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