I have been trying to calculate the RSD of two bracketing reference standards based on the TOTAL Area of the summed peaks. I have tried a few things however none have worked.
I have filtered the table to provide the 2 reference standards in question using Calibration_Level. I have tried adding a custom field and using SUM(Peak_Area), however when trying to calculate anything it gives the error about using 2 nested aggregate functions. I then tried assigning the initial Sum(Peak_Area) as an expression variable with the injection ID as key, however when I try and run the RSD on that table it is greyed out, or populates the table with "NaN".
I am using OpenLab CDS Version C.01.05
Has anyone had a similar problem or could point me in the right direction?
It sounds like you are trying to do this on a sequence summary report template. Is that correct? Is it possible for you to post the template that you have been working on, or at least screenshots, so we can see how you are setting everything up?
Also, I added tags to this post to make it more visible on the community.