Agilent Community
Agilent Community
  • User
  • Site
  • Search the Community
  • User
Software
  • Technical Areas
  • More
Software
Wiki How to ... calculate summary statistics on computed numbers
  • Announcements
  • Forum
  • Files
  • Videos
  • Wiki
  • More
  • Cancel
  • New
Software requires membership for participation - click to join
  • OpenLab CDS(ver. 2.x) Data Exporting as Archive file
  • Wiki
  • .X Data file
  • 7694B Headspace No Longer Supported With OL EZchrom or CDS
  • A simple template to calculate Relative Retention Times (RRT) (OpenLAB CDS Intelligent reporting)
  • AcqOrderNumber in OpenLab EZChrom Edition C.01.03 (and earlier)
  • Another calibration report for OpenLAB CDS ChemStation
  • Another calibration report for OpenLAB CDS EZChrom
  • Autostart macro failed error 999 in OpenLAB CDS ChemStation
  • Batch and Sequence menus missing in Drugquant E.02.02. sp2
  • Belarc Advisor for PC Profiling
  • Calculate date and time differences - Save date and time in IR
  • Calibration History Report (OpenLAB CDS)
  • Chemstation .CSV generation Decimal Places
  • Chemstation Chemmain Error During Startup
  • Chemstation E.02.02 SP2 Batch Summary Report does not run.
  • ChemStation Scheduler Commands
  • +Collection of MassHunter Productivity App Resources
  • Collection of OpenLab CDS ChemStation Edition Resources
  • Collection of OpenLab CDS EZChrom Edition Resources
  • Collection of OpenLab CDS Resources
  • Collection of OpenLab CDS, OpenLab Chemstation, MassHunter, and Reporting Videos
  • Computer Maintenance
  • Configuring OpenLAB CDS Chemstation for a 6890 with 3rd party detector
  • Configuring Windows Firewall For GCMSD MassHunter Acquisition
  • Connection to selected server failed Error 1068 - dependency service failed
  • Considerations when Adding Custom Methods to the MassHunter Productivity App
  • Create a Custom Report Method for the MassHunter Productivity App
  • Creating a New Result Set From Self-Assembled Result Sets - OpenLab CDS (ver 2.x)
  • DAMethod Register Export
  • Data Review Protocol with Filter Sets in the MassHunter Productivity App
  • DrugQuant is not an option in G1701FA GC/MSD Software until you specify an MS
  • ECM user cannot find data file on ECM server using  GCMS Chemstation.
  • Edit Labname in Report Header, Chemstation E.02.02
  • Error in autotuning tied to missing XML - Masshunter GCMS
  • Error Message "No Signals Available" appears when loading data
  • Error Message: Vial Range -1 to -1 - OpenLAB CDS Chemstation
  • Error: No Export File Selections Made Yet - OpenLAB CDS Chemstation
  • Features coming with the next release of IR in ChemStation/EZChrom and New Data Analysis (2013 August 01 OpenLAB Intelligent Reporting)
  • GCMS MassHunter Installation Guide
  • Host System not Ready - GC/MSD System
  • How to .. hide a table row based on a calculated value (OpenLAB CDS Intelligent Reporting)
  • How to ... add a percent sign to a PRSD number.
  • How to ... add LC diagnostic data to Intelligent Reports (OpenLAB CDS Intelligent Reporting)
  • How to ... add several comments to your report template without generating extra space on the report (OpenLAB CDS Intelligent Reporting)
  • How to ... align text boxes to the editor's grid (OpenLAB CDS Intelligent Reporting)
  • How to ... align uncalibrated peaks in 2 or more signals
  • How to ... auto-extract signals from a UV iso-absorbance plot
  • How to ... calculate summary statistics on computed numbers
  • How to ... calculate with a specific mutiplier or dilution factor generated by OpenLAB CDS EZChrom
  • How to ... change page footer size (OpenLAB CDS Intelligent Reporting)
  • How to ... export sequence results to comma separated txt files (OpenLAB CDS Intelligent Reporting)
  • How to ... filter for EZChrom run types QC Standard  (OpenLAB CDS Intelligent Reporting)
  • How to ... populate the template editor with your data
  • How to ... print ChemStation's live system values (OpenLAB CDS Intelligent Reporting)
  • How to ... protect a template from modifications (OpenLAB CDS Intelligent Reporting)
  • How to ... refer to compound specific constants stored in a larger table
  • How to ... report the number of repeated injections with OpenLAB CDS EZChrom
  • How to ... report the output of a category aggregator  (OpenLAB CDS Intelligent Reporting)
  • How to ... scale time axis to show the time range between 2 named reference peaks - OpenLAB CDS Intelligent Reporting
  • How to ... set up bracketed calibrations in a report template
  • How to ... store a date stamp as a variable? (OpenLAB CDS Intelligent Reporting)
  • How to ... use external report parameters (OpenLAB CDS Intelligent Reporting)
  • How to .... deploy customized composite groups to other projects, clients, users
  • How to .... generate PDF Bookmarks  (OpenLAB CDS Intelligent Reporting)
  • How to .... report peak-to-valley ratios (OpenLAB CDS Intelligent Reporting)
  • How to ....remove the report template revision number from the page footer (OpenLAB CDS Intelligent Reporting)
  • How to ...change the date format (OpenLAB CDS Intelligent Reporting)
  • How to ...  setup an array of compound specific parameters
  • How to Add a GC Instrument in OpenLab CDS (Ver 2.x)
  • How to Check the Signal-To-Noise Ratio With OpenLab CDS (ver 2.x)
  • How to configure Agilent GC headspace system within Waters Empower and ICF
  • How to Create a Multipoint ESTD Calibration Method with OpenLab CDS (ver 2.x)
  • How to Export OpenLab System Activity Log and Diagnostics Logs for Troubleshooting
  • How to Hide the Top Triangular Mark of the Peaks in the Intelligent Report with OpenLab CDS (ver 2.x)
  • How to Integrate Merged Peaks in OpenLab CDS
  • How To Overlay Chromatograms in OpenLAB CDS Chemstation
  • How to Review Completed Injections in a Running Sequence in OpenLab CDS (ver 2.x)
  • How to Semi-Quantitate Unknown Compounds in MassHunter Quantitative Analysis
  • How to sum up peaks before and after an identified compound (OpenLAB CDS Intelligent Reporting)
  • How to... add a forced page break (OpenLAB CDS Intelligent Reporting)
  • How to... print ChemStore Custom Fields with OpenLAB ECM Intelligent reporter
  • How to... report sequence related customized parameters (OpenLAB CDS Intelligent Reporting)
  • How to.... do bracketing calibration calculation within the report template (OpenLAB CDS Intelligent Reporting)
  • How to...document a report template definition and calculation formulas on paper? (OpenLAB CDS Intelligent Reporting)
  • HowTo : Report the n Biggest Peaks of a sample analysis (OpenLab CDS Custom Calculator)
  • ICPMSD SDA Compliance Software Frequently Asked Questions
  • Instructions for Enabling Compound Math on B.03.0x-B.07.00
  • Introducing PDF Style Reporting and Copy to LIMS
  • KB: Useful Free Third-Party Software Tools
  • Little script to print Text and Numbers as Results ( e.g. below detection limits ) (OpenLAB CDS Intelligent Reporting)
  • LookInMyPC - PC Profiling and Diagnostics
  • Make your own custom way of displaying the Date and Time in your reports
  • Migrating from OpenLAB CDS EZChrom Edition to OpenLab CDS Version 2.3 – Workstation to Workstation
  • MSD Error: HPMSAXQ0.DLL failed upon launching Openlab - OpenLAB CDS Chemstation
  • No MS Data Found - G1701FA Chemstation Drug Analysis.
  • Notepad++
  • Openlab CDS C.01.07 and 6890 classic driver
  • OpenLAB CDS ChemStation C.01.07 Failing Install on Disk 2
  • OpenLab CDS ChemStation – Sequence Template Printout Too Many Pages
  • Optimizing Efficiency with Compound Groups in the MassHunter Productivity App
  • Out of Memory Warning on MassHunter
  • Overcome Problems with decimal delimiters or other characters (OpenLAB Intelligent Reporting)
  • Peak result matrix report template (OpenLAB CDS Intelligent Reporting)
  • Preventing Chemstation from crashing because of HP printer driver dll fault
  • QA check report divide by zero error
  • Reprocessing data using a new calibration table
  • Resetting a Tune file to default 5977 MSD
  • Result Error Statuses in the MassHunter Productivity App
  • Result Flags in the MassHunter Productivity App
  • Sequence Aborted Due to File Access Error - OpenLAB CDS Chemstation
  • Sequence container/result set data will not load in navigation panel - OpenLAB CDS Chemstation
  • Streamlining Sequence Setup in the MassHunter Productivity App
  • Tune and Vacuum Control Error: Undefined Symbol ADJ_WIDTH or AXIS
  • Tuning Retention Times in the MassHunter Productivity App
  • Video Series: OpenLab CDS for ChemStation Users
  • When trying to run a sequence, user gets error "macro has no name"
  • Wrong quant results shown in QEdit when using TIC as quant signal or importing AMDIS results
Related Tags
  • administration
  • agilent support insights
  • app
  • ChemStation
  • data analysis
  • error
  • error message
  • EZChrom
  • GC
  • GC/MS
  • instrument administration
  • instrument operation
  • Intelligent Reporting
  • MassHunter
  • MassHunter Productivity App
  • OpenLab
  • OpenLab CDS
  • OpenLab CDS ChemStation Edition
  • OpenLab Intelligent Reporting
  • productivity
  • report
  • reporting
  • software
  • troubleshooting
  • troubleshooting aids

How to ... calculate summary statistics on computed numbers

Whenever a table column is defined by a calculation expression containing a variable it is not possible to use the built-in summary statistics.

A variable can not store multiple values at a time and for summary statistics you need to store the multiple values in an array. The aggregator function of the expression editor could be used to setup the array and to calculate the summary statistics.

 

However, the output of this aggregator cannot be placed in the footer of a table. Template editing with BI studio or direct editing of the RDL file do not change the situation.

 

Aggregator results needs either be reported in a single value field, in another column of the result table or in a column of another table.  A single value fields cannot be appended to a table, but you can position it fairly close.

 

The attached report and template contains 3 examples showing possible solutions.

 

Example 1: The Mean and RSD values are printed as individual name/value pairs. By choosing a generic table layout, the fields can be positioned right below the table. Do not activate the standard summary calculations, because the additional footer line will disturb the positioning of the Mean and RSD fields.

 

Example 2:  If you intend to report multiple summary calculations based on multiple parameters you can use individual text fields to setup a matrix like shown in the example. Copy/paste allows you to build this 'matrix' fairly quick.  Use the grid alignment to get the boxes sized and positioned.

 

Example 3:  This example calculates the aggregator in a hidden table.  The final results are displayed in a second table including further calculations (delta) based on the aggregator output.

 

(originally posted in OpenLAB Forum: https://zohodiscussions.com/openlabcdsforum#Topic/68030000000134001

2014 September 11 by betrich)

Attachments:
8272.attachment.zip
  • OpenLab CDS
  • OpenLab Intelligent Reporting
  • OpenLab
  • Intelligent Reporting
  • reporting
  • Share
  • History
  • More
  • Cancel
Was this helpful?
  • Yes
  • No
Thank you for your feedback!

Agilent Community Feedback

Agilent Community Feedback

×
We are glad this was helpful! We are sorry this was not helpful. If you still need assistance please create a community post or contact support. To help us improve, please provide any additional feedback. For full details of how we will treat your information, please view our privacy policy.
Submit Cancel
Submit Cancel
Related
Recommended
Privacy Statement
Terms of Use
Contact Us
Site Help