Choose function Intelligent Reporting OpenLab CDS 2.5


I'm creating a system suitability report, which I want to use for both EP and USP plate count. In case of EP lab, the USP pharmacopoeia is not selected in processing method, in case of US lab, EP pharmacopoeia is not selected in processing method.

How can I create a function in my report column which reports only USP or only EP plate count? I need Peak_TheoreticalPlates_EP or Peak_TheoreticalPlates_USP but don't know how to tell the report to make a decision.

Top Replies

  • Hi

    To make the choice, us a formula like the one below in the value section of the column properties of your table

    =IIF(Peak_TheoreticalPlates_EP > 0, Peak_TheoreticalPlates_EP,Peak_TheoreticalPlates_USP…

Was this helpful?