Empower AVE/Mean Custom Field

[malivgee1]

Hi,

We use Empower CDS for our analytical routine. Using two processing methods in the sample set allows us to process one sample separately for assay and related substances at the same time.
To calculate the corrected amount of the sample, we use a Custom Field with the following formula:
SAME.%..AVE(Amount_corr), where Amount_corr=Amount*Density
The issue is that this Custom Field calculates the mean for both related substances and the assay component together within one sample.

When we inject same sample twice (Label: U01), we expect to receive a separate mean calculation for the compound (Assay in this case). However, this Custom Field combines all four results (assay+ related substances from both injections) into a single mean calculation. This is not the desired outcome.

Is there a way to modify the Custom Field so that it calculates the mean only for assay in samples and mean only for related substances in related substances processed data?

Or may be: Is it possible in the Relative Substance Processing Method to exclude the API peak, so it wont be reported?

Thanks and best wishes
Marina

[EmpowersBane]

Create a derived channel in your method set for each processing method, and you can call the first one Assay and put the assay processing method against it and then call the second one Related Substances and put the related substances processing method against that. Then change your formula to:

SAME.%.SAME.AVE(Amount_corr)

Process your sample set to generate a result set using the process with method set option and Empower will then calculate the average amount but only per channel so the Assay channel and then the rel subs channel and then you should get the answers you want. To create a derived channel, right click the method set, New Derived Channel.

[malivgee1]

Create a derived channel in your method set for each processing method, and you can call the first one Assay and put the assay processing method against it and then call the second one Related Substances and put the related substances processing method against that. Then change your formula to:

SAME.%.SAME.AVE(Amount_corr)

Process your sample set to generate a result set using the process with method set option and Empower will then calculate the average amount but only per channel so the Assay channel and then the rel subs channel and then you should get the answers you want. To create a derived channel, right click the method set, New Derived Channel.

Hi,

Thanks a lot for the idea! I have tried to follow your instructions, but unfortunately, it didn’t work. I will share the screenshots of the Method Sets I've created, as well as the Sample Set. If you have time to check them, maybe you will spot the error.

Again, thank you so much for your help—it is really appreciated.

Method Set Assay+RS (HPLC 100_F_MG):
Method Set Assay (HPLC 110_F_A_MG):
Method Set RS (HPLC 110_F_RS_MG):
Sample Set:

Thank you!

[EmpowersBane]

Hi and thanks for the reply. I cant see the images you posted can you maybe send them as a link?
Can you set the assay samples as controls and the related substances samples as Unknowns? Then your formula can be set to Controls Only so then when you process the sample set, only the Assay (Controls) peaks will be included for averaging.

You can do similar with the related substances sample- if its Unknowns only then only the 2 injections of related substances (Unknowns) will be included.

[malivgee1]

Hi and thanks for the reply. I cant see the images you posted can you maybe send them as a link?
Can you set the assay samples as controls and the related substances samples as Unknowns? Then your formula can be set to Controls Only so then when you process the sample set, only the Assay (Controls) peaks will be included for averaging.

You can do similar with the related substances sample- if its Unknowns only then only the 2 injections of related substances (Unknowns) will be included.

Hi - thank you for replying as well and sorry for the inconvenience.

Unfortunally it is impossible to change the Sample Set's characteristics, as it is strongly connected to the SOP. As you an see (hopefully) in the sample set, we inject 9 RS Standards, following by 6 Assay Standards and having samples as 'Unknown'. After 12 Samples injections the control standard comes..
All the other custom fields functioning except the 'AVE' one..

Sample Set:https://ibb.co/W4f0R23W
Method Set Assay+RS (HPLC 100_F_MG): https://ibb.co/TM8WMzhz
Method Set Assay (HPLC 110_F_A_MG): https://ibb.co/xtDsL6jV
Method Set RS (HPLC 110_F_RS_MG): https://ibb.co/dsCKLDTs

Thanks for the help!
Beste Wishes
Marina

[EmpowersBane]

Can you use a report method and suitable filters using labels etc to get the average value? Instead of a custom field. Or do you need a custom field?