topic Can I use JMP formulas to refer to a single value present in a column on a JMP data table? in Discussions

Can I use JMP formulas to refer to a single value present in a column on a JMP data table?

TaqyPoly — Fri, 09 Jun 2023 16:05:21 GMT

The data table below has been generated on Excel and then copied to JMP

I'd like to perform a logic test which involves the following steps -

1. Ordering the "Parameter" column in descending order

2. Checking whether each of the values in the "Parameter" column is greater than 25% of the highest value in the Parameter Column. If it is - the logic column should display "TRUE" else "FALSE".

I don't know how to reference a cell in the formula on JMP like you can on Excel (e.g. - $A$1)

Re: Can I use JMP formulas to refer to a single value present in a column on a JMP data table?

jthi — Wed, 21 Dec 2022 19:25:04 GMT

Is there are reason why you couldn't just check if each row is greater than 25% of the highest value immediately?

You can check for maximum value in column by using Col Max()

If(:Column 2 >= Col Max(:Column 2) * 0.25,
	"TRUE",
	"FALSE"
)

You can of course sort the data if you need to by right clicking on the column header and selecting Sort Ascending/Descending

One way to access row and column is to use , you can also use column reference and then row number like :Column 2[1]

Also a good read

Re: Can I use JMP formulas to refer to a single value present in a column on a JMP data table?

TaqyPoly — Wed, 21 Dec 2022 20:17:40 GMT

This worked! Thank you for the links :D