Custom Calculation between two areas in different samples

Problem in your formula is that you are selecting samples for different roles based on the sample name - some substring in the name. Also you dont indicate how you want to deal with multiple std and/or multiple kal in a sequence. Moreover, you would require a value stored across whole sequence, which is probably not easy using CC. Better use reporting. 

Maybe you can use blank subtraction?

Hello,

It looks like you are creating this at a sequence level scope so an example of doing a simple fairly static calculation would be as follows. This example would take the average peak area of peak A from all injections with the name SSS and divide that by the average area of peak B for injections with the name CSS. The where statements are the filters and the select is the data you would like to extract. These CC would be scope of sequence and type double.

CurrentSequence.AllIdentifiedPeaks.Where(function(x) x.Compound_Name = "Peak A").Where(function(x) x.Injection.Sample.Sample_Name = "SSS").Select(function(x) x.Peak_Area).Average / CurrentSequence.AllIdentifiedPeaks.Where(function(x) x.Compound_Name = "Peak B").Where(function(x) x.Injection.Sample.Sample_Name = "CSS").Select(function(x) x.Peak_Area).Average

If you needed the 1st multiplier of a specific injection you could get that with a CC like.

CurrentSequence.AllIdentifiedPeaks.Where(function(x) x.Injection.Sample.Sample_Name = "SSS").Select(function(x) x.Injection.Sample.Multiplier(1)).Average

Marty Adams

Marty, you are da man!

He sure is :-D

Thank you very much for your help :-D