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 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)