The following is my idea for sharing
- create table to show RT and filter by identified peak, and save into a variable (e.g. reference), hide the table
- create table to show unknow peak, and formular RT unknow/reference
Pls see attached template, you may want to change filter in 1st table (hidden table) to known compound.
...or also can define retention time range in the filter.
Thanks for the recommendations, unfortunately in my initial request I forgot to mention two important points:
- The report should be applicable for many different methods with different peak names
- There will be more than one reference peak
Specifically requirement 2 is tricky as one can't access individual data inside an aggregator.
I have now solved it for 2 compounds by simply using min/max aggregator functions. This covers 80% of my methods.
Attached is the RDL (Impurity Report.rdl), a document describing the template (2012-0920_impurity-report.docx) and an example sequence (RRT 2012-09-20 00-17-27.zip)
2012-0920_Impurity+Report.zip 334.0 KB
Maybe you can use report parameter to define RT high and low, then filter according report parameter to define reference peak. Save this peak as variable, for RRT calculation
I went ahead and flagged the "Correct Answer" on this post. If you still need help though, please let us know and we would be happy to continue working with you.