cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
jlmbs
jlmbs
Level III

Column formula

Created: Jun 29, 2022 05:37 AM  |  Last Modified: Jun 10, 2023 4:50 PM (671 views)

I am trying to write a formula for a data table that allows me to subtract the %Area of each glycan species in the sample set. An example would be:

d%Area = (%Area of G0 in A) - (%Area of G0 in B)

How can I write the formula to group by sample name and glycan species?

giulia_lambiase_0-1656495403599.png

 

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
HadleyMyers
Staff HadleyMyers
Staff
Solution

Re: Column formula

Jun 29, 2022 06:17 AM (663 views)  |  Posted in reply to message from jlmbs 06-29-2022

Hi,

 

Not sure if spliting the table is a possibility?  If so, you can save the Split Script to the original data table and modify it to add the formula column.  Please take a look at the table below with the saved table script and see if this can work for you.

View solution in original post

Split Table Formula Column example.jmp
1 REPLY 1
HadleyMyers
Staff HadleyMyers
Staff
Solution

Re: Column formula

Jun 29, 2022 06:17 AM (664 views)  |  Posted in reply to message from jlmbs 06-29-2022

Hi,

 

Not sure if spliting the table is a possibility?  If so, you can save the Split Script to the original data table and modify it to add the formula column.  Please take a look at the table below with the saved table script and see if this can work for you.

Split Table Formula Column example.jmp