Agilent Community
Agilent Community
  • User
  • Site
  • Search the Community
  • User
  • Home
  • Technical Areas
    Technical Areas
    • AssayMap
    • Atomic Spectroscopy
    • Automated Electrophoresis
    • Bioreagents
    • Cell Analysis
    • Consumables
    • CrossLab Connect
      CrossLab Connect
      • Service Management
      • Smart Alerts
    • Dissolution
    • Gas Chromatography
    • GC/MS
    • LC/MS
    • Liquid Chromatography
    • Molecular Spectroscopy
    • Sample Preparation
    • Software
      Software
      • Chromatography Software
        OpenLab CDS, OpenLab ChemStation, OpenLab EZChrom
      • Data Management Software
        OpenLab ECM, OpenLab ECM XT, OpenLab Server
      • Mass Spectrometry Software
        Data Analysis, Data Acquisition, Productivity App, WalkUp Software
    • Vacuum
  • Applications Areas
    Applications Areas
    • Basic Research
    • Energy and Chemicals
    • Environmental
    • Food and Agriculture
  • Agilent Knowledge Portal
  • Links
    Links
    • Collection of Support Resources
    • Webinar Notifications
    • Contact Support
    • User Contributions
  • Getting Started
    Community Help and Resources
  • Browse
    Browse
    • People
    • Places
    • Your View
    • Your Community Inbox
Chromatography Software
  • Technical Areas
Chromatography Software
Wiki How to ... calculate summary statistics on computed numbers
  • Announcements
  • Forum
  • Files
  • Videos
  • Wiki
  • More
  • Cancel
Actions
  • Share
  • More
  • Cancel
Table of Contents
  • +Software Collection of Resources
  • 7694B Headspace Sampler Software Support
  • Another calibration report for OpenLAB CDS ChemStation
  • Another calibration report for OpenLAB CDS EZChrom
  • Autostart macro failed error 999 in OpenLAB CDS ChemStation
  • 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 Scheduler Commands
  • OpenLab CDS and Windows 7 Podcast
  • Computer Maintenance
  • Configuring OpenLAB CDS Chemstation for a 6890 with 3rd party detector
  • Connection to selected server failed Error 1068 - dependency service failed
  • DAMethod Register Export
  • 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
  • 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 ... 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 ... 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 ... store a date stamp as a variable? (OpenLAB CDS Intelligent Reporting)
  • How to ... use external report parameters (OpenLAB CDS Intelligent Reporting)
  • How to ...  setup an array of compound specific parameters
  • How to configure Agilent GC headspace system within Waters Empower and ICF
  • How To Overlay Chromatograms in OpenLab ChemStation
  • How to... report sequence related customized parameters (OpenLab ChemStation Intelligent Reporting)
  • HowTo : Report the n Biggest Peaks of a sample analysis (OpenLab CDS Custom Calculator)
  • 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
  • Notepad++
  • Openlab CDS C.01.07 and 6890 classic driver
  • Reprocessing data using a new calibration table
  • Sequence Aborted Due to File Access Error - OpenLAB CDS Chemstation
  • Sequence container/result set data will not load in navigation panel - OpenLAB CDS Chemstation
  • Video Series: OpenLab CDS for ChemStation Users
  • When trying to run a sequence, user gets error "macro has no name"
Still Need Help?

Post your question in our User Forum or Contact Support.

How to ... calculate summary statistics on computed numbers

Created by Agilent Agilent over 2 years ago | Last modified by kristen.sensabaugh kristen.sensabaugh over 1 year ago

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
  • Sign in to reply
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
Privacy Statement
Terms of Use
Contact Us
Site Help