BookmarkSubscribeSubscribe to RSS Feed
Highlighted
DBiber

New Contributor

Joined:

Mar 7, 2018

Using specific row values for use in a formula

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.

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: Using specific row values for use in a formula

Try this formula

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

Community Trekker

Joined:

Sep 15, 2014

Re: Using specific row values for use in a formula

@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)); 
Best
Uday
txnelson

Super User

Joined:

Jun 22, 2012

Solution

Re: Using specific row values for use in a formula

Try this formula

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