• State Verified Answer
  • Replies 4 replies
  • Subscribers 116 subscribers
  • Views 843 views
  • Users 0 members are here
Related

Agilent Knowledge Portal

Find maintenance, best practice, and troubleshooting articles.

Agilent Knowledge Portal

Average Blank Subtraction as Opposed to most recent blank in CDS 2.6 custom calculation

ChemistKML

Is there a way to build an equation with a sample_type enumerator in the aggregator. For example, Avg(Sample_Type=5) does not generate a working number. Is there a work around that can define the parameters as injections 2 and 3 and then just divide by CountDistinct(Sample_Type) to create an average value. I am trying to do this to generate an average blank as opposed to the most recent blank sample concentration value.

Parents
  • +1

    Hello,

    Are you trying to do this in IR or custom calculator? In IR you would need to create a table or field filtered by sample type 5, and then store the peak area as an indexed aggregator by compound name. You could then use the average of the aggregator to do your calculation in subsequent tables. You can hide the first table so it does not show on the report. The other option would be to do the calculation in CC and then report or use the CC value in your IR report.

    Marty Adams

  • 0 in reply to martin.adams

    Hello,

    Also this would only allow you to use the blank values for reporting calculations. If you are trying to subtract the raw data of the blank from the other injection there is no way to do this the software will only use one blank file. This is the only way for the blank to effect say the calibration curve.

    Marty Adams

Reply Children
No Data
Was this helpful?
Privacy Statement
Terms of Use
Contact Us
Site Help