How do you calculate peak area ratio in the current injection for intelligent report?
The more elegant and, as it turns out easier, is to create a custom calculation file with two calculations. The first finds the area of the named peak:
The second uses this value to calculate the ratio.
Add this cc file to the processing method
You can now see the results directly in Data Analysis
You can get these results in a compound results table too
There you go!
Please provide more information about the software you are using (can find product and revision by going to either Help>About or File>About) as well as the calculation you are wishing to perform.
What EXACTLY do you want calculated when you mean peak area ratio?
I am using Openlab CDS 2.4. I would like to calculate the ratio between impurities (known/unknown) with my main named peak.
E.g: %impurity = (peak area impurity/peak area main peak)*100
Are the impurities all saved in the method as individual compounds? Or are you using a named or timed group to report the impurities?
And is there only one main peak per injection? Or multiple main peaks each with its own impurity peaks?
The impurities are saved as individual compounds and there is only one main peak.
You could do the calculation directly in an Intelligent Report or as a custom calculation.
I assume that you're used to editing Intelligent Report templates...
For the calculation in a single injection report I would normally add a compound results table and apply a filter to only show results for the main named peak. In this example, the main compound is Ethyl paraben.
I would then save the area for this peak as a variable, so that I can use it in another table:
I can then add a second compound results table. Add a custom column to the table with the formula to calculate the result that you want.
The resulting report will have two tables.
You can use the Advanced settings to hide the first table from the report.
Hope that all makes sense!
I'll post how to do this with a custom calculation later!
Thank you for the reply and info. That's what I ended up doing after thinking about it. It thought there would be a more elegant way.
Please do share for the custom calculation, that would be helpful.
Perfect! Thank you very much.
Retrieving data ...