multiple injection calculation

[ricopalazo]

Hi all!
A quite simple question about Empower custom field.
How to average multiple injections for the same sample, and doing this for multiple sample (each sample has his average) in a summary of analysis.
I think that i need to use label... Next, when the custom field is developped, I have to insert the custom field in a summary table.
Is it right?
What is the syntax to use for the custom field?

Thank you all

[aceto_81]

How about using the summary field in your report?
You can add average there. Group your tables as you want (eg SampleName, Component, ...) and just print your report.

Ace

[ricopalazo]

To complete my question.
For multiples injections of the same sample, I want an average (area) to be able to calculate the average value of the injections. Then I want to average the average injections values of all the sample of my sequence:

mean sample 1 injection 1; 2; 3 =A
mean sample 2 injection 1; 2; 3 =B
mean sample 3 injection 1; 2; 3 =C

Mean A;B;C=D

I want to be able to calculate A, B, C and D in the same summary.
I found that I have need a custom field like this %.%.average(area) to calculate A, B or C. For calculating D, it's just the mean of A, B, C (I think I don't need a custom field to do that).
For the moment, i'm not able to use the %.%.average(area) function because I don't know exactly if the syntax is right and where to use it (directly in summary?).
Can anyone helps me?

Rico

[EmpowerGuru]

Sample_Average = SAME.%.%.AVG(Area)

This will give you the initial averages of the the injections for each sample.

You need to make the label unique for each sample and the same for each injection. So if you used multiple injections per row, this is easy.

Then use the report to average these three values. You will have to filter the table to only show injection three, otherwise the table will show you the same average three times. So make the report only show the third injection, if possible, and right click the sample_average column and add a summary function (average). This part will not be possible unless you setup the sample set with three injections per row.

If you set it up with individual rows for each injection let me know and I can help you out if need be.

[DR]

I think I would do it via duplicate result tables that use different ordering and grouping values.

Table one - normal, component grouping, summary statistics per labels (U01xx mean, stdev etc, then U02xx and so on) - if needed, make additional tables for each group, filtering by sample label (U01*, U02*...)

Table (type) two - order by component, filter by sample type (unknown), then all unknowns w/ a given component can have the same summary statistics applied to the column of your choice.

I don't think you need custom fields for this, you can do it by reusing the same table and altering the ordering and filtering options on them.

[ricopalazo]

Thank you Guru, that's exactly what I was searching for.
Let's try...

Rico