Error default values for the Compound summary table

Hello,

It seems to be an error with that table configuration. The check mark is the important selection for the calculation, the label is just a text label. It seems the other table objects have the correct default labels. 

Marty

Compound Summary

Peak Results 

Yeah I choose the good row RSD and it is working well. I don't why we have the default row from a default Agilent table wrong. 

I also tried to calculate % recovery as your colleague Richard showed in this quick video.

Calculate Percent Recovery of Samples in OpenLab CDS (3931628) (on24.com)

But I have a infinite value. Richard said it might be the way the variable was set. But I did exactly as he told. 

I tried to do it as sample type 4 (control). Here an example with Methanol-EIC. We can see that the value calculated from this QC with the Cal is okay. But when I tried to divided by the the mean value enter the the Cal level, we have infinite value. 

I can send you the email exchange with Richard this morning. 

I can send it to William Cody, if you don't want to share your email here. 

Thank you for your help. 

Hello,

How are you entering the value for the recovery? Is this a rerun of a standard level or are you entering the information as a compound custom field? The infinity means you are dividing by 0, so I would assume one of your values in the expression is 0. If you are using a custom field t could be that your value is text not a number to resolve that put it inside a Val() function. I could not open the video for some reason. 

Marty

I can send the video by email if you want. But I did exactly as Richard said on his video. I first create a new sequence summary report template as he asked in the video. I also used the  Compound Summary table as report item to start. 

I put filter sample type =1 (Cal.Std) and also filtered by compound name that contains EIC. 

It has default sorting that I don't know how to manage it. Do I need to delete those sorting? 

So after that I went to the amount column properties and click on the average to put a variable. 

After, like Richard showed in the video, I copy this exact table and I only change the sample type 1 for sample type 4 so I can calculate the recovery on the amount calculated by the 1 point curve. 

I added a column custom field column to add the % recovery calculation. 

And I see infinite as a result. 

What's wrong? 

I can send the video by email if you want. But I did exactly as Richard said on his video. I first create a new sequence summary report template as he asked in the video. I also used the  Compound Summary table as report item to start. 

I put filter sample type =1 (Cal.Std) and also filtered by compound name that contains EIC. 

It has default sorting that I don't know how to manage it. Do I need to delete those sorting? 

So after that I went to the amount column properties and click on the average to put a variable. 

After, like Richard showed in the video, I copy this exact table and I only change the sample type 1 for sample type 4 so I can calculate the recovery on the amount calculated by the 1 point curve. 

I added a column custom field column to add the % recovery calculation. 

And I see infinite as a result. 

What's wrong?