create compound summary table with average of multiple injections

Hello

I typically run a sequence of at least 10 different samples, with 3-5 injections per sample. I would like to create a report template that will  give a compound summary table and display only the average concentrations from 3 injections, instead of 3 different reports or 1 table with each compound name repeated 3x for each injection.

Ideal situation would be a template similar to Short_quant_ESTD format, but i can select multiple injections and using a template generate a simple table (maybe even chart) that uses the average values instead if individual injections

I tired changing the value to = avg(compound concentration) however its gives the mean of all compounds in an injection rather than average the same compound over multiple injections.

Is what i am trying even possible? It would make it significantly easier to generate reports direct for clients if so.

Thanks in advance for any help

Parents Reply Children
No Data
Was this helpful?