Subscribe Bookmark RSS Feed

Formulas in JMP

none1

Community Trekker

Joined:

Apr 9, 2014

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 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

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.

6281_JMPScreenSnapz007.png

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

6283_JMPScreenSnapz009.png

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.

6284_JMPScreenSnapz010.png

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