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

- JMP User Community
- :
- Discussions
- :
- Formulas in JMP

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

Highlighted

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

May 12, 2014 5:41 AM
(10994 views)

I have been trying to write a formula since morning to refer to certain cells in my JMP table, however I seem to be able to get no where.

I can make a clear general statement: When it comes to Formulas Excel is a far ahead of JMP.

Its difficult to understand why its SO SO SO difficult even simple formulas in JMP !

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Created:
May 12, 2014 6:28 AM
| Last Modified: Oct 18, 2016 1:42 PM
(11283 views)
| Posted in reply to message from none1 05-12-2014

I'm sorry that you're frustrated in your attempts to use the Formula Editor in JMP.

The first thing to recognize is that JMP isn't a spreadsheet like Excel (neither is Excel a structured data table like JMP).

When you create a new column and give it a formula. The formula applies to the entire column and is evaluated for every row in the column.

If you want to reference a specific row in a column you can use the Subscript option from the Row functions.

This will give you a subscript for the column you've got selected in the formula. You can put a row number in the subscript and you'll get the value for that column in the row specified.

This formula returns the value for ABRASION in row 3 for every row of this new column.

Can you tell us what you're trying to do and how you've tried to do it and we can give you some pointers to accomplish it?

-Jeff

-Jeff

5 REPLIES 5

Highlighted

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

Created:
May 12, 2014 6:28 AM
| Last Modified: Oct 18, 2016 1:42 PM
(11284 views)
| Posted in reply to message from none1 05-12-2014

I'm sorry that you're frustrated in your attempts to use the Formula Editor in JMP.

The first thing to recognize is that JMP isn't a spreadsheet like Excel (neither is Excel a structured data table like JMP).

When you create a new column and give it a formula. The formula applies to the entire column and is evaluated for every row in the column.

If you want to reference a specific row in a column you can use the Subscript option from the Row functions.

This will give you a subscript for the column you've got selected in the formula. You can put a row number in the subscript and you'll get the value for that column in the row specified.

This formula returns the value for ABRASION in row 3 for every row of this new column.

Can you tell us what you're trying to do and how you've tried to do it and we can give you some pointers to accomplish it?

-Jeff

-Jeff

Highlighted
##

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

Re: Formulas in JMP

I'm experiencing the same kind of problem. In my data set I have a column named "Month", with readings , "Jan,Feb, Mar,.........,Dec" and am trying to create a new column named "month2" which converts the Month to "01(for Jan), 02 for (Feb), 03 (for Mar), ...... , 12 (for Dec). I'm assuming an "IF" statement will be useful. Please assist me on how to go about this

Highlighted
##

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

Re: Formulas in JMP

Here is a formula that will give you a numeric value for month

```
monthList={"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
contains( monthList, :Month );
```

Jim

Highlighted
##

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

Re: Formulas in JMP

Thank you

Highlighted
##

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

Re: Formulas in JMP

Created:
Aug 20, 2018 6:31 AM
| Last Modified: Aug 20, 2018 10:24 AM
(9474 views)
| Posted in reply to message from ZosTa 08-20-2018

The recode tool or the mach function would be handy as well:

`Match( :Month, "Jan", "01", "Feb", "02", "Mar", "03", "Apr", "04", :Month )`

Article Labels

There are no labels assigned to this post.