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

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

=IIF(Compound_Amount > 0.5,  Format(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: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000137005

2014 September 24 by ukirchhoff)