Multiplication in Agilent Report Builder 10.2

Question

Hello howard_sanford 
 
 I am updating our report template and I have one last column to create. 
 
 Basically, all I want to do is this--> {V:LimitOfDetection}*{V:Dilution} 
 I want a column that displays the Limit of Detection multiplied by the dilution factor of the sample. 
 I cannot have a fixed value for the dilution factor as we adjust it every time. 
 
 Can I use an expression in the report template to achieve this? 
 
 Thank you for your time and Have a nice day

howard_sanford · Accepted Answer

Canadian_Chemist , 
 There is an example of printing text instead of the final concentration based on the LOQ outlier in this discussion. 
 (+) Report builder - Final Concentration Expression Change - Forum - Mass Spectrometry Software - Agilent Community 
 Either of those expressions should work, depending on whether you want to report blanks the same as other sample types or not. Remember to change the binding name to match what you are using in your template. 
 For the calculation you would just use an expression like the following - 
 BoundItems["cmp"].LimitOfQuantitation*BoundItems["sample"].Dilution 
 Again replace "cmp" and "sample" with the binding name used in your template. This expression will only work if all compounds and all samples have a LOQ and dilution specified. If not, the report will fail. To make it more robust you could add some checks as in the previous example and just have it print nothing if any of the values are missing. 
 "" if BoundItems["sample"].IsDilutionNull() or BoundItems["cmp"].IsLimitOfQuantitationNull() else BoundItems["cmp"].LimitOfQuantitation*BoundItems["sample"].Dilution

howard_sanford · Answer

Hello Canadian_Chemist , 
 The preview function requires that you specify the full path for any graphics you add. The exception to this seems to be the default logo.tif graphic, which appears to work even if the file is completely missing. 
 The easiest way to get the full path for a file is to shift-right click on the file in the File Explorer and choose the option to copy as path. Paste this into a temporary text document, remove the double quotes, and then copy/paste the path into report builder. 
 If you are running the report from quant then you don't need to specify the full file path. Just having the graphics file in the same folder as the template should work.

howard_sanford · Answer

Hello Canadian_Chemist , 
 Yes, you can create an expression to do that. There is an example in this post about how to do that. 
 (+) Can a User Defined value be converted to use in calculations? - Forum - Mass Spectrometry Software - Agilent Community 
 You won't need to worry about converting either of your values to a number, but the idea is the same. 
 There are also several expressions you could look at in the template posted to this discussion. 
 (+) Add statistics (mean, stdev) for a column in MassHunter Report Builder - Forum - Mass Spectrometry Software - Agilent Community

Multiplication in Agilent Report Builder 10.2

Top Replies