In openlab ezchrom, we had a custom report that if a compounds concentration was over the alert limit column, there was another column with a function that said alert or blank. See picture below.
Each compound has a different alert limit so I would need to input these numbers for each compound.
The table should have:
Compound Name, Compoud concentration, Exceeds Alert, Alert limits (inputted numbers that don't change). How can this be done in Openlab CDS 2.4?