Reporting "<" values in ChemStation

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

3 posts Page 1 of 1
With an intelligent report, is there a way to add conditional formatting field so that any values below calibration report as "<LOQ" or a similar text?
You need to create an IF statement in the value field
=iif(compound_concentration<value,"<LOQ",compound_concentration)

Of course you can replace Copmpound_concentration by Compound_Amount or Area or whatsoever.

iif is not a typo! it has to be that way
Freek Varossieau
OpenLab CDS 2 specialist
BeyondOpenLab
beyondopenlab@gmail.com
+5977114721
Thank you!
3 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry