Offset of data within the injection sequence [Reporting, OpenLab 2.5]

Question

Hello,

I would like to implement a calculation in the Custom Calculation Editor that moves a value of another Custom Calculation up one row in the injection order. Example: a value from Injection 2 should be output in the row of Injection 1.

Is this possible in any way?

Thanks and best regards
coh

martin.adams · Accepted Answer

Hello, 
 
 Yes this is possible as long as the data is in the same results set. A simple example is below. This would take the peak area from the previous injection for the matching peak name and place it in a custom field. This would be done for all named peaks. The next example would take the peak area of the previous standard injection before the current injection. It would again do this for all named peaks. You could make this even more complex by creating other CCs as an index or reference to use in the CC for selecting another injections peak_area or other value. 
 
 Marty Adams 
 
 CurrentSequence. AllIdentifiedPeaks . Where ( function (x) x. Injection . Sample . Sample_OrderNumber = CurrentSample. Sample_OrderNumber - 1 ). Where ( function (x) x. Compound_Name = CurrentPeakOrGroup. Compound_Name ). Select ( function (x) x. Peak_Area ). Sum. 
 
 CurrentSequence.AllIdentifiedPeaks.Where(function(x) x.Injection.Sample.Sample_Type = 1).Where(function(x) x.Injection.Sample.Sample_OrderNumber < CurrentSample.Sample_OrderNumber).Where(function(x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name).OrderBy(function(x) x.Injection.Sample.Sample_OrderNumber).Select(function(x) x.Peak_Area).Last

Offset of data within the injection sequence [Reporting, OpenLab 2.5]

Top Replies