Advertisement

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 are 366 users online :: 0 registered, 0 hidden and 366 guests (based on users active over the past 5 minutes)
Most users ever online was 4374 on Fri Oct 03, 2025 12:41 am

Users browsing this forum: No registered users and 366 guests

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