Reporting Custom Field Values

lczenith
lczenith
in Software Products
Hi all,

I am traying to bring a STD result such as STD AVE(AREA) from 3 injection (same vial, label 201, S02, S03) to the unknown sample injection  to create another CF. I am trying this CF:Peak, Real, Calculated, Result set first: SAME...CCompRef1[STD_Concentration], but does not work.

Any idea?
Thanks

Answers

  • Jovvor
    Jovvor
    The custom field does not work as you reference to the same label.
    summarize custom fields are composed as: Label.Injection.Channel. Summarize function(function)
    An intersample calculation is different: Label.Injection.Channel function

    To bring the average Area of those 3 injections you will have to create a custom field to calculate average of these values. Remember that these standard injections need to be injected before your unknowns as the average value will only be calculated correctly after all Area's have been filled.

    You can check the All or Nothing box, but not sure if that works.
    You can also add summarize custom fields to the end of your sample set so empower will fill this field in every row in.

    Custom field for the average
    Peak,Real,Formula: (S01.1.(Area)+S02.1.(Area)+S03.1.(Area))/3

    That should bring a value to your unknown sample injections where you can use it to calculate further.




  • lczenith
    lczenith
    Hi @Jovvor, thank you for this answer.

    To do the Custom field for the average STD, I created this Formula: Peak, Real, Calculated, result set first: S%.%..AVE(Area) 
    In this case the Label were: 3 injections from same vial, S01 for all. So this is why I just did this     S%.%..AVE(Area), works and appear in the unknown sample injections. 

    But I would like also to bring to     unknown sample injections the CF result of: STD_concentration that appear in the STD injections.

    Thank you once again.
     
  • Jovvor
    Jovvor
    It works just the same for the Area as for the STD_concentration.
    You can replace the Area with your STD_concentration.
    Or replace the formula with: S%.%..AVE(CCompRef1[STD_concentration])
  • lczenith
    lczenith
    Hi @Jovvor, thank you again.

    This CF "STD_concentration" is prevenient from others CF from the "Components Tab", so I think this is the reason that the result of this CF S%.%..AVE(CCompRef1[STD_concentration]), does not appear in the unknown sample injections. Do you think the same?


    Thank you.

  • Jovvor
    Jovvor
    That is possible, check in review the column properties of your custom field.
    The Data Type should be double precision float.
    Else it will not be recognized as a number and Empower cannot make an Average out of it.
  • lczenith
    lczenith
    Hi @Jovvor thank you for the answer. I cheked the CF and the Data type is Double precison float. Please let me know if you have more ideas to sove this problem. Thanks.
  • Empower2019
    Empower2019
    Anytime CCompRef1-3 is used for a custom field formula, the result will never show up for an unknown, only for the peaks designated as CCompRef1-3.If you want the result to display for knowns and unknowns change the CCompRef1 to CCalRef1:

    S%.%..AVE(CCalRef1[STD_concentration]),
  • lczenith
    lczenith
    Hi all, thanks both.

    @Empower2019 this CF (S%.%..AVE(CCalRef1[STD_concentration])) unfortunately does not work; and I have another question: firstly I was using this CF S%.%..AVE(Area)  just for one API now I am using for 3 API and the AVE of Area does not appear in the control and unknow injections. I don´t no why. Thanks

  • Empower2019
    Empower2019
    Check the sample type and peak type of your custom fields. They should be set to All for all your custom fields so that standard custom field values can still be applied to unknown and control samples. Also dont tick all or nothing plus make sure you have a search order of Result Set Only and batch process a sample set to generate a result set. There is no reason why you cant do the above calculation unless there is no value for STD_concentration for the peak designated as CCalRef1?
  • lczenith
    lczenith
    Hi all,

    I am doing this CF because I don’t want to do any calculation outside of the Empower. So, the problem is when I have more than one API to quantify. I am avoiding to use the “CCalRef” specially when I have more then one API. About my questions, please see below the Figures.

    Regarding this CF: S%.%..AVE(Area), when I choose “Result Set Only” don’t appear any results. When I change to “Result Set First” the results for Standard injection appear equal to the area and for unknowns don’t appear any results, as I said when I have more than one API.

    As you can see in the Figure of the CF STD1_Concentration, I am created a lot of CF taking into considerations all the standard amount and dilutions. So to calculate the assay of the unknowns samples I need to bring the average area and concentration of the standard to the unknow samples injections.

    Once again thank you both for all help.











  • lczenith
    lczenith
    Hi all, 

    I have the current sequence (see below). It is possible to do a CF to report the STD area for the unknown sample injection (note that I have just one injection for each)?

    Label    -  SampleName
    S01       -     STD01
    S02        -    STD02
    S03       -     STD03
    U01      -      Sample1
    U02      -     Sample2
    U03     -      Sample3

    Thanks.

Categories