Little script to print Text and Numbers as Results ( e.g. below detection limits ) (OpenLAB CDS Intelligent Reporting)

Document created by agilent Employee on Mar 24, 2016Last modified by agilent Employee on Mar 24, 2016
Version 2Show Document
  • View in full screen mode

Because the format of the IR can't use with IFF conditions you can format within the IFF condition

=IIF(Compound_Amount > 0.5Format(Compound_Amount, "0.000" ) , " Below Limit")


0.5 in the example can be replaced by a custom field contend like betrich described it just before or by a report parameter or any variable which has defined.

=Val(Trim(Choose(1,Split(Sample_DilutionFactors, ";" ))))



(originally posted in OpenLAB Forum:

2014 September 24 by ukirchhoff)