Hello There
Is there an easy solution to the following requirement;
A sequence summary table grouped by compound/peak where the average peak area is reported from all replicate injections in each sequence line.
In many cases we carry out duplicate injections from each sequence line then we report the mean response for each peak and currently complete operation this in EXCEL.
We are operating in OpenLab2.4
Thank you in advance for any feedback
Geraint
Hello,
I have added tags to this post to increase visibility.
You could use a customer calculation file to calculate the average peak area for each compound across all replicate injections for each sequence table line. The below expression should accomplish this:
Average("Peak_Area",CurrentSequence.AllIdentifiedPeaks.Where(function x.Compound_Name=CurrentPeakOrGroup.Compound_Name).Where(function x.Injection.Sample.Sample_OrderNumber=CurrentSample.Sample_OrderNumber))
Then you can just setup your results table to repeat for each compound and add a column in the table to report the result from this custom calculation.
Hello,
The way Ryan indicated to do the custom calculation will work but depending on how you want to present the data in the table there is another option in IR. You could use an internal group in the table object. You would create and edit a group in the table. You can group by Sample_OrderNo as in the custom calculation example or you could use vial number, sample name, some another variable unique to your replicates. Once you have the group you can include calculations(average, stdev, sum, ect.) for the columns in the table. You can only display theses values, they cannot be stored for use later in the template.
