3 Replies Latest reply on Jan 30, 2019 11:14 AM by martin.adams

    Value format in a Table that reports a Custom Calculation

    camelia

      Hi

      I am reporting the RT and output from the following CC in Openlab 2.3 in 2 columns in a table

      =if(ROUND(CCR((Compound_CustomCalculationResults),"CC1"),3)>=0.035,ROUND(CCR((Compound_CustomCalculationResults),"CC1"),2),"<LOQ")

       

      The problem is I need the CC output to display to 2 decimal places and the Value Format option for this column is not available in the report. For example, although a result of 14.796  is displayed as 14.8 (so it is correctly rounded to 2 numbers) I need the report to output 14.80.

      Is there a way round this problem?