MassHunter Report Builder 10.2.1 Expression to Reference Different LOQs?

Question

I have a large compound list with 2 different LOQs, and in the FinalConcentration field of the report I would like it to compare the value against each compound's respective LOQ and if it is less than that, report "< the LOQ value". For examle, if the concentration is 0.0001 and LOQ is 0.001, report <0.001, for another compound where LOQ is 0.005, report <0.005 in that case. 
 
 I assume it's somethijg like this: 
 "<LOQ" if BoundItems["TargetPeak"] is None or BoundItems["TargetPeak"].IsFinalConcentrationNull() or not BoundItems["TargetPeak"].IsOutlierBelowLimitOfQuantitationNull() else BoundItems["TargetPeak"].FinalConcentration 
 
 for "<LOQ" I'd like it to actually recall the specific LOQ value and report that instead of just the same string of text.

howard_sanford · Accepted Answer

Hello SeanPath , 
 There is an example in this discussion that shows how to vary the LOQ text. 
 (+) Report builder - Final Concentration Expression Change - Forum - Mass Spectrometry Software - Agilent Community 
 At the end of the post is the trick for creating the LOQ text itself, using Python string conversion functions to extract the LOQ for a target and make it a string. 
 
 For converting numbers to strings there are several Python or .NET functions or methods you could use. The simplest is str(). This will convert the number as it comes from quant to a string. 
 "< "+str(BoundItems["TargetCompound"].LimitOfQuantitation) 
 If you want to change the number of decimal places used, you could use the format() method 
 "< "+format(BoundItems["TargetCompound"].LimitOfQuantitation,'.3f') 
 This would convert to a string with 3 decimal places.

MassHunter Report Builder 10.2.1 Expression to Reference Different LOQs?

Top Replies