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

Version 2

    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 Bernhard Etrich 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: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000137005

    2014 September 24 by Uwe Kirchhoff)