Page 1 of 1

Taking an average using Custom Fields

Posted: Mon Jun 27, 2011 2:41 pm
by greg123
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

Re: Taking an average using Custom Fields

Posted: Mon Jun 27, 2011 10:55 pm
by Don_Hilton
Which software are you using?

Re: Taking an average using Custom Fields

Posted: Mon Jun 27, 2011 10:56 pm
by greg123
Empower 2

Re: Taking an average using Custom Fields

Posted: Tue Jun 28, 2011 5:14 pm
by MO Chemist
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.

Re: Taking an average using Custom Fields

Posted: Tue Jul 12, 2011 3:01 pm
by EmpowerGuru
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.