SumArea in OpenLab CDS C.01.05 [40], identifiead and unknown peaks

Question

Hello! Please help with the creation of the report in in OpenLab CDS C.01.05 [40] 
 1. I need to calculate the sum of the areas of all the peaks except for the peaks called Isobornyl acetate and levomenthol. 
 That is, my final formula is: 
 =SumArea - Area(Isobornyl acetate) - Area(levomenthol) 
 2. The sum of the areas of all peaks should include the area of all peaks: identified and unidentified. But in the report, I would like the unidentified ones not to be displayed, because the list of peaks is very large (3 sheets). 
 Can anyone help me with this, please?

martin.adams · Accepted Answer

Hello, 
 Is this for a summary report or single injection report? I will show an example for a summary report where you need this value per injection. Attached is an example PDF. 
 Marty Adams 
 
 Add a single field like peak area to the top of the report and group it with itself.

In that groups properties, repeat the group by injection ID or acquisition date which are both unique fields for each injection. Also place filters to exclude your named peaks from the group. In my example, I exclude Peak A and Peak B.

Once this is done the group will contain all peaks except the 2 that were filtered out and will repeat for all injections. Now you can change the value of the field to = Sum ( Peak_Area ) and store it as a variable keyed on injection date or ID.

You will probably not want to see the field at the top of the report so you can hide that group once you make sure it is working for the value you want. Once this is done you can use that stored value in any table below to display the area sum of all the peaks except the selections that were filtered.

/cfs-file/__key/communityserver-discussions-components-files/26/Agilent-Example.pdf

SumArea in OpenLab CDS C.01.05 [40], identifiead and unknown peaks

Top Replies