turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Re: Using specific row values for use in a formula

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

A week ago
(73 views)

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

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

A week ago
(109 views)

Solution

Try this formula

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

Jim

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

A week ago
(67 views)

@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

Uday

Highlighted
Solution

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

A week ago
(110 views)

Try this formula

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

Jim