cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
jlmbs
Level III

Column formula

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Column formula

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

1 REPLY 1

Re: Column formula

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.