Is it possible to include samples with zero amounts in the sample statistics in the report?

Hello,

I would need to know what software and version you are using CDS 2.x, Chemstation, or EZChrom. In later versions of IR for those products if you include missing peaks in the tables, they will show blanks which will not be included in the summary calculations. If you use an expression like  =If(Compound_Concentration>0,Compound_Concentration,0.0) to show a zero for missing peaks then that will be included in the summary statistics. 

Hallo, I am using Openlab CDS Version.2.7. I try that with the include missing peaks in the tables, but nothing happened.

Hello,

Did you start with one of the available reports or build a new one? There may be a filter on table or group the table is in that is keeping missing peaks from displaying. You need to look at any grouping or the table itself for active filters. Retention time > 0 is a common one used to remove missing peaks. 

Marty

Right now i have two different sample statistics. The first two pictures are the statistic table from the sample that have a concentration. The last two pictures are the Samples hat dont have amounts. And i want to have one statistics table , with sample with amounts and without. I tried your suggestion, but did not help to fix that.

Thank you very much vor your help

Hello,

Is that a report template you created from scratch or is it one of the existing templates provided with the software? If it is new, what table object did you add for those sections? There are several groups around that table, did you check each group for filters? 

Marty

The first i created that from scratch. The second one is of the existing with some changes, but not in the filters.

The beginning:

But with Cal samples

Hello,

In that last image the table is showing missing peaks. Maybe I am not understanding the problem. Are the missing peaks not showing at all in your tables or is there another issue? As I said before there are only 2 reasons for missing peaks to not be displayed. One is that the table itself is not set in peak filters to display missing peaks. The other option is a specific filter is set on the table or surround group that removes missing peaks. If you can get the missing peaks to display, then you can use the other expression to force 0 values. Remember you will need to alter that expression for the value you are trying to display. 

=If(Compound_Concentration>0,Compound_Concentration,0.0)

=If(Peak_Area>0,Peak_Area,0.0)

Marty Adams 

Hello,

In that last image the table is showing missing peaks. Maybe I am not understanding the problem. Are the missing peaks not showing at all in your tables or is there another issue? As I said before there are only 2 reasons for missing peaks to not be displayed. One is that the table itself is not set in peak filters to display missing peaks. The other option is a specific filter is set on the table or surround group that removes missing peaks. If you can get the missing peaks to display, then you can use the other expression to force 0 values. Remember you will need to alter that expression for the value you are trying to display. 

=If(Compound_Concentration>0,Compound_Concentration,0.0)

=If(Peak_Area>0,Peak_Area,0.0)

Marty Adams 

The last table are showing missing peaks, thats right. But inside the table are the calibration runs and i only want the sample runs with concetration and without. How can i exclude the Injection calibration runs ( CAL=Calibration run)  from this table and only keep the sample runs (Prob=Sample run) in correct sequence?

Which filtering i need?

Thanks you for your help.

If you are labelling your calibration runs as "Cal. Std." in their "Sample type" field, simply add the filter Sample_Type <> 1. If you aren't labelling them as such, you'll need to tell us another difference between the ones you want to remove and the ones you want to keep.

Hello,

As Cole said you need to be selecting the correct sample types in you sequence to use this. If you are doing that, the filter would be Sample_Type <> 1 to remove the calibration standards or Sample_Type = 3 for just samples if you have other sample types to filter out. See the enumeration table for sample type below from the CDS help. Some items in the table are for EZChrom, but 1,3,4,5,7,9,15 are used in CDS 2.x as possible sample types.