Empower 2 Custom Field ?
<p>I am having an issue with custom fields. I want to get the average of another custom field that I created.</p><p>I have several samples labelled (U01, U02, U03....U20). I want the average of a custom field for the those 20 samples (I'll use CUSTOM_X as the field name).</p><p>The sample set is set to don't process for everything and there are Quantitate and Summarize Custom Fields rows at the end that are set to normal.</p><p>I need to see this average value (I'll call it AVG_CUSTOM_X) for each sample as I need to use this value in another custom field.</p><p></p><p>Right now I can't get the average to diplay for each sample only for the last one. I'll show an example of what is happening below.</p><p>(Example values for CUSTOM_X would be 10, 20, 30, 40, 50).</p><p></p><p>For sample 1 AVG_CUSTOM_X is showing as 10</p><p>For sample 2 AVG_CUSTOM_X is showing as 15 (average of 1 and 2)</p><p>For sample 3 AVG_CUSTOM_X is showing as 20 (average of 1, 2, and 3)</p><p>For sample 4 AVG_CUSTOM_X is sohwing as 25 (average of 1, 2, 3, and 4)</p><p></p><p>It keeps doing this until the last sample which shows correctly. In the example above it would show AVG_CUSTOM_X = 30.</p><p></p><p>I don't understand why it is iterating through the average rather than showing me the overall average for each sample. I have a ticket open with Waters and they are looking at this as well but they haven't figured it</p><p>out in the last couple of days so I am posting here in case someone has seen this before. </p><p></p><p>Thanks!</p>