Advertisement

Taking an average using Custom Fields

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

5 posts Page 1 of 1
Hi

I am trying to create a custom field to take the average of a custom field i already created so i can use that value in another custom field.

I made a custom field to find the Response Factor of my Standard that is bracketed throughout my run and has a certain concentration. From this I want to take the average of that to plug into another custom field.

This new equation should look like (Total Peak Area of Sample/Ave Response Factor of Standard)/Injection Volume.

I am asking to see if anyone knows how to take the average of all the response factor values i am calculating for my Standard to use in that equation.

Thanks
Greg
Which software are you using?
Empower 2
This should work,
S%.%..AVE(Resp_Fact_CF)

S% is all the labels of the standards in the run. Resp_Fact_CF will be the response factor custom field that was created. It is a peak field type. Gotta make sure all the standards are labeled S something.

Hope it works for you.
Sometimes when you have intersample custom fields embedded into other custom fields the naming is important. The custom fields are calculated in alphabetical order. So if you ever can't get something to calculate, try naming them in the order they should be calculated.
5 posts Page 1 of 1

Who is online

In total there are 51 users online :: 0 registered, 0 hidden and 51 guests (based on users active over the past 5 minutes)
Most users ever online was 5108 on Wed Nov 05, 2025 8:51 pm

Users browsing this forum: No registered users and 51 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