-
- Posts: 12
- Joined: Mon Feb 22, 2016 6:04 pm
- Location: USA
Results from two of the vials are used as the blank
I need to average the two peak heights between the two vials and if the average height is equal to or less than 100 then use the 100 as the blank value. Once the sample's height is corrected for the blank we multiply it against a response factor
+ There often isn't a peak for the constituent which was giving me some issues with the calculation failing completely. I found this to be due to the value being a Null(); therefore, I've creating a custom field:
Result Set Only, Real, Peak
NoNullHeight: Replace(Height,0)
This works fine returns zeros for the missing peak values
+ The issue I have now is trying to get the average height between the two blank vial results to subtract from the current sample's peak height.
I labeled the two blank samples "Blk" and following some information I've found online about inter-sample custom field calculations I've tried
Result Set Only, Real, Result
AvgBlkHeight: EQI(Name,"PeakName")*Blk...AVE(NoNullHeight)
This results in an error about peak/component fields need a SUM,MIN,MAX,AVE function; however, this equation appears to have one.
I'm at a loss at this point.
The Response factor will be entered into the processing method as CCONST2
Thank you for any help you can offer, the more I read the tutorials I could find online about the Empower Custom Fields the worse I understand them.