Solution 2

If the Spike added concentration is not fixed, you need to enter it into the CDS. You can for example, create a Compound Custom Field for that.

In the Control Panel, add a compound custom parameter to your project. Then define the value of the compound custom parameter in the acquisition sequence table or in Data Analysis injection list.

In the Control Panel

In Acquisition

In Data Analysis

Formula

• Scope: Peak or Group

• Type: Double

• Formula:

  IF(Sample_Name like "Pair*", (AllMatchingPeaksAndGroups( MatchOption.Compound, CurrentSequence.AllInjectionsBySampleName(Sample_Name)).Last().Compound_Amount - AllMatchingPeaksAndGroups( MatchOption.Compound, CurrentSequence.AllInjectionsBySampleName( Sample_Name)).First().Compound_Amount)/ CurrentPeakOrGroup.GetCustomField("SpikedAmount")*100, "")

Explanation of the formula:

Part of equation (highlighted)	Description
IF(Sample_Name like "Pair*", (AllMatchingPeaksAndGroups(MatchOption.Compound, CurrentSequence.AllInjectionsBySampleName( Sample_Name)).Last().Compound_Amount - AllMatchingPeaksAndGroups( MatchOption.Compound, CurrentSequence.AllInjectionsBySampleName( Sample_Name)).First(). Compound_Amount) / CurrentPeakOrGroup.GetCustomField("SpikedAmount")*100, "")	Returns the value of the spiked amount of the current compound.