EIC report with smaller chromatogram to reduce the number of pages in the report

Hello,

The explanation from the Openlab Help and Learning is copied below. Depending on where you are using the resultant value you may need to place the expression in a Val() function. 

Marty

Show only part of a value

Depending on the value of a data field, you may want to show only part of the value.

For example, the data fields Sample_DilutionFactor and Sample_Multipliers show five numbers separated by semicolon, but only part of the numbers may be set by the chromatographic data system. Therefore the value may look like 10; 0; 0; 0; 0 if only the first number is set. To display only the number 10 instead of the entire string, you can use the following expression:

=Choose(1, Split(Sample_Multipliers, ";"))

• The Split function divides the string in several parts, using the semicolon as a delimiter. In this example, the different parts are the single numbers.

• The Choose function selects and returns a specific value from a list of values. In this example, it returns the first value, that is, the number 10.

it works but I obtained a value of 1. It is supposed to be 10. I put 10 as multiplier in the calibration table and it also works to calculate concentration in ppm (ug/g). 

But in the injection list, the five multiplier are at 1. 

I am not sure what's wrong here. 

I need to use the function related to the multiplier used in the process method. 

Which multiplier is used in the concentration mass % ? 

Based on my results, the multiplier need to be a 10 in order to give my result in ppm. It seems to work. I will do a test tomorrow addind another multiplier and check if my sample's results are affected. 

If you add this to a sequence summary report, what it would do is show only the first injection or if they are in stacked mode it may show all injections at once on the same plot. If you change the sorting you can get a different order instead. What I expect you would want is for it to repeat for every injection. I don't know what you have it repeating on currently, if anything, but if it is already repeating on something, then you can simply put another group around it and set that to repeat by injection_ID, sorted by sample_OrderNo and Injection_AcquisitionOrderNo (to make sure it goes first to last injection).

Thank you for the advice. I appreciate that. 

If you don't want it to show only one calibration point, then you need to filter it to show only the last calibration injection. What I've done to resolve this so far is in a different field go filter by sample type for only cal standards, sorted by sample_OrderNo, then store the last sample_orderNo. Then in another field go filter by Sample_OrderNo, sort by injection_AcquisitionOrderNo, then store the last Injection_AcquisitionOrderNo. Then in the calibration curve filter by the stored Sample_OrderNo and Injection_AcquisitionOrderNo. That should give you the calibration curve as of the last calibration injection. If you want to see how it works better, just repeat on injection_ID and you will see the calibration curve build up one point at a time.

Also, I think your response is by percent because you have either the "Normalize to" or "Calculate mass %" boxes checked in the calibration general settings. I've included a snip to show where they are. I recommend playing around with those to see your options. I haven't done much with them so I can't help much more than that.

I need the % mass because the other option do not take into account the sample weight that I can put in my injection list for process. 

So the method will ask to the analyst to put sample weight in mg in the injection list. The concentration will be the amount founded by the one point curve (limit test) in ug divided by sample weight. I need to add multiplier to transform mg of sample into gram. The conversion scale is 1000 but since I already multiplied by 100, I have to add a 10 fold multiplier. 

And it works perfectly. I can show the concentration calculated like that in ppm (ug solvant/g of sample)

9.84 ug founded with my one point curve is then divided by the sample weight 25 mg gives 0.3936 ug/mg. In order to transform it into PPM (ug/g) we need to multipliy by 1000. 394 ppm and that's what we obtained. So the calculation is perfect without doing any custom calculation. Very simple. 

But the problem is that I can't show my multiplier used in my sequence table into the sequence summary table in my report for our data revisor. 

Also, by choosing this % mass, my response axis is in % amount based on calibration point. I can live with that if we can't change it to raw unit counts. 

But I need to find a way to show my multiplier factor in my sequence table.