Hello,
Have you ever encountered a problem with the injection result of a CC:
I have encountered this problem with the result display for the CCs: "PATeneurUT5" and "PATeneurUT10" .I have encountered this problem for the CC's: "PATeneurUT5" and "PATeneurUT10" which once did not display. and after
closing the resultset and reopening it followed by a process, the values were displayed.
Are these formulas written correctly?
CC : PATeneurUT5first : currentinjection.AllPeaksAndGroupsByName("PA").where(function(x) x.Injection.Sample.sample_name like "*UT5*").Where(function (x) x.Compound_AMOUNT = CurrentPeakOrGroup.Compound_AMOUNT).select(function (x) x.Compound_AMOUNT/500). first()
CC : PATeneurUT5MoyenneAverage : CurrentSequence.AllPeaksAndGroupsbyname("PA").Where(function (x) x.Injection.Sample.Sample_Type = 3) .Where(function (x) x.Injection.GetStringCC("Nomslots") = CurrentInjection.GetStringCC("Nomslots")).Where(function (x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name).Select(function(x) x.GetDoubleCC("PATeneurUT5")) .Average()
CC : PATeneurUT10first : currentinjection.AllPeaksAndGroupsByName("PA").where(function(x) x.Injection.Sample.sample_name like "*UT10*").Where(function (x) x.Compound_AMOUNT = CurrentPeakOrGroup.Compound_AMOUNT).select(function (x) x.Compound_AMOUNT/1000). first()
CC : PATeneurUT10Average : CurrentSequence.AllPeaksAndGroupsbyname("PA").Where(function (x) x.Injection.Sample.Sample_Type = 3) .Where(function (x) x.Injection.GetStringCC("Nomslots") = CurrentInjection.GetStringCC("Nomslots")).Where(function (x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name).Select(function(x) x.GetDoubleCC("PATeneurUT10")) .Average()
CC : PATeneurUT : if(CurrentInjection.sample.sample_name like ("*UT5*"),PATeneurUT5,if(CurrentInjection.sample.sample_name like ("*UT10*"),PATeneurUT10,if(CurrentInjection.sample.sample_name like ("*UT25*"),PATeneurUT25,"")))
cc: Nomslots : CStr(Split ( sample_name, "-" )( 0 ))
Example sample name :
lot1 UT5-D1:PATeneurUT5 PATeneur UT5Average: AVERAGE(lot1 UT5)
lot1 UT5-D2:PATeneurUT5
lot2 UT5-D1:PATeneurUT5 PATeneur UT5Average:AVERAGE(lot2 UT5)
lot2 UT5-D2:PATeneurUT5
lot1 UT10-D1; PATeneurUT10 PATeneur UT10Average :AVERAGE(lot1 UT10)
lot1 UT10-D2: PATeneurUT10
lot2 UT10-D1: PATeneurUT10 PATeneur UT10Average:(Average(lot2UT10 )
lot2 UT10-D2: PATeneurUT10
Thank you for your advice and help
SYB