How to Remove "No Data" from Report Output Generated from SCIEX OS Software｜質量分析計・LC-MS/MSシステムのSCIEX

For research use only. Not for use in diagnostic procedures.

Issue Description

When using a report template with SCIEX OS software, the report output may indicate "No data" in red if there is no text in the corresponding column in the results table.
 

Resolution

An IF/ELSE statement can be created to filter out the “No data” response in a report.
If no outliers are displayed in the results table, and the report shows “No data for MQ Outlier Reasons” in the column, then use the following IF/ELSE statement in the report template.

IF EXACT($MQ_Outlier_Reasons,'')
ELSE (Text Field: MQ_Outlier_Reasons)