How can I create a custom calculation which will determine if any blanks in a sequence have peaks?

I am using the following code to determine if any peak in the blank has an area greater than our reporting limit peak area. However, in my report any blank without peaks is not analyzed. I'd like to report that no peaks were detected but am struggling to find a good way to do that.

If(Sample_Type=5,
If(Compound_Name.Length < 1
"N/A"
If(Peak_Area < CurrentSequence.AllIdentifiedPeaks.Where(function (x) x.Injection.Sample.Sample_Type = 7).Where(function (x) x.Compound_Name = "DrugA").Select(function(x) x.Peak_Area).Last,
"Below",
"Above")), 
"N/A")

Parents
  • I am having this issue elsewhere as well. How can I report in the results table that nothing was detected? Example below of another custom report section where no peaks which fit the criteria are reported. How can I report that this blank space is due to lack of peaks which fit my criteria? 

    UPDATE:

    I solved my original challenge by creating a custom calculation that counts the number of peaks at the injection level and using that count in my blank evaluation criteria. However, my second issue persists. How can I report that a table which has all peaks filtered out of it is intentionally left blank because no peaks fit the criteria?

Reply
  • I am having this issue elsewhere as well. How can I report in the results table that nothing was detected? Example below of another custom report section where no peaks which fit the criteria are reported. How can I report that this blank space is due to lack of peaks which fit my criteria? 

    UPDATE:

    I solved my original challenge by creating a custom calculation that counts the number of peaks at the injection level and using that count in my blank evaluation criteria. However, my second issue persists. How can I report that a table which has all peaks filtered out of it is intentionally left blank because no peaks fit the criteria?

Children
Was this helpful?