How to report EIC signal description as scan m/z value

Question

Hi, I am trying to report an EIC as the extracted value rather than the asymmetric range. For example, I extracted 126.0 with an asymmetric (-0.3/+0.7) expansion range as shown below: 
 
 But in the reporting template, I want a column that shows the extracted value (126.0) rather than the range 125.7-126.7. 
 
 What is the best approach to reporting the extracted single point value? 
 Thank you!

martin.adams · Accepted Answer

Hello, 
 
 You turned the value back into a number by dividing by10 outside the formatnumber statement. I would just place the entire statement in a Val() function and then format the column as 1 decimal place. 
 
 Marty 
 
 =Val( If ( Signal_Name like "*EIC*" , FormatNumber (Fix( Val ( Choose ( 1 , Split ( Choose ( 2 , Split ( Signal_Name , "-" )), ")" ))) * 10 - 7 ), 1 ) / 10 , "TIC" ))

How to report EIC signal description as scan m/z value

Top Replies