I would like to know if there is a way that I can programed on the intelligent report Average and %CV of total area for multiple injections?
I will show you the simplest way to do this calculation. The example here will calculate the total area of all peaks in each standard injection and give the average and CV% for the replicate pairs. You should be able to adapt these concepts to use this for the injections of your choice by alter the filters or grouping.
First add a table to the report like the sequence overview that displays each injection as a single line. Then add the peak_area column to the table and edit the column properties for that new column. Change the Peak_Area value expression to add the aggregate sum so it is Sum(Peak_Area). This will sum all the peak areas in the injection and display the value. Now create a aggregator, using the save expression result as button, which will allow you to store the values in the table in an array which you can use to generate your calculated values.
Now below the table you will add 2 single fields and change the label and value to display the aggregate the you stored. You can select the the aggregator calculations from the fields in the expression editor to obtain the required values. The first would be Avg(YourAggregator) and the second =(Stdev(YourAggregator)/Avg(YourAggregator))*100 or PSRD(YourAggregator).
Once you have the table setup and the fields to display your values now we will group and repeat the table and fields to display only standards and group them by level. First select the table and fields then right click and select to group them together. Once that is done the group box can be selected and the properties edited to repeat the group by Sample_CalibrationLevel. Also in the group properties, the filtering can be set to exclude all sample except the standards.
The last issue for a report like this where you are repeating a table with an aggregate, if you want the values to be independent for each repetition of the group then you need to clear the aggregetor. So you place a field in the group at the bottom and use the Clear(YourAggregator) function to clear out the value. Then that field can be hidden by unchecking the visibility option.
Please provide us with the software product (OpenLab CDS, OpenLab ChemStation, OpenLab EZChrom) that you are using as well as the revision (found by going to either Help>About or File>About).
I also would like to use the aggregators created to program my own calculations but doesn't seem to works when I use aggregator from different tables. This is what I'm trying to program:
I have one sample acquired at two wavelengths (A280nm and A690nm). Since I need the average total area of both wavelength by separately and different aggregator names I created two tables, to capture each total area value and average total area by separately and assigned an aggregator name to each average total area (Avg(TotalArea1) for 280nm and Avg (TotalArea2) for 690nm.
To program the desired formula I need to use both aggregators and I can't get it right:
If you need to use those values outside the group and they are from groups that do not repeat then do not clear the aggregator. In my example I cleared the aggregator because the group repeated and I wanted the aggregator to only reflect what was in each repetition of the group.
That was really helpful. Wondering If I can define the amount of decimal places for the Total Area programed as Sum(Peak_Area) as well as for the Average and %RSD calculated.
Sure every field should have a value format where you can set the numeric formatting. Sometimes if you are doing custom calculations the field may not realize the value is numeric if that is the case only string formatting will be available. If this is the case sometimes that can be resolved by placing the calculation inside a Val() statement. If you do this and apply the change check the format again to see if it allow numeric formatting. If that does not work you can build in formatting in the calculation formula using the VB statements FormatNumber or Format.
To add to Marty's suggestions, you could use the Round() function that takes two arguments Round(NumberToBeRounded, NumberOfDecimalPlaces).
So many ways to do the same thing!!
Retrieving data ...