Highlighted

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

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

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

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