Empower 2 Custom Field ?
I am having an issue with custom fields. I want to get the average of another custom field that I created.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).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.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.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.(Example values for CUSTOM_X would be 10, 20, 30, 40, 50).For sample 1 AVG_CUSTOM_X is showing as 10For sample 2 AVG_CUSTOM_X is showing as 15 (average of 1 and 2)For sample 3 AVG_CUSTOM_X is showing as 20 (average of 1, 2, and 3)For sample 4 AVG_CUSTOM_X is sohwing as 25 (average of 1, 2, 3, and 4)It keeps doing this until the last sample which shows correctly. In the example above it would show AVG_CUSTOM_X = 30.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 itout in the last couple of days so I am posting here in case someone has seen this before. Thanks!