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!
Hello,
You can try this expression to extract the second mass and convert it to x.0.
=FormatNumber(Truncate(Val(Choose(1,Split(Choose(2,Split(Signal_Name,"-")),")")))),1)
Thank you for this! I am getting closer to what I'm looking for! I had to tweak your suggestion a bit because I will not always be extracting masses ending in .0 (the extracted mass will frequently end in .1 or .9, for example, I may need 126.0, 245.1, 254.9, etc). With this expression:
=If(Signal_Name like "*EIC*", FormatNumber(Fix(Val(Choose(1,Split(Choose(2,Split(Signal_Name,"-")),")")))*10-7),1)/10,"TIC")
I get the following output:
Which reports the EIC without the extracted range. This is perfect, but I have not been able to get the 126 to report as 126.0. While this isn't critical, I would prefer the decimal if possible. Do you know a way to make this .0 report for this case? I tried a few things unsuccessfully.
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"))
