How we can bring 12 different peak type custom field in one peak type custom?

Jahangir1986
Jahangir1986
in Software Products
I have 12 different peak type (data type: real) custom fields, named as- T1S1, T1S2, T1S3, T1S4, T1S5, T1S6, T1S7, T1S8, T1S9, T1S10, T1S11 and T1S12. Theses are percent dissolved result at time point 1 of 12 different tablets. I want to bring these 12 different peak type custom fields in one peak type custom (data type: real). Please anybody help me.

Best Answers

  • Jahangir1986
    Jahangir1986
    Answer ✓
    I have 12 different percent dissolved custom fields of 12 different tablets, named as-T1S1, T1S2, T1S3, T1S4, T1S5, T1S6, T1S7, T1S8, T1S9, T1S10, T1S11 and T1S12. (T1 is stands for Time point 1 and S1 is stands for Tablet 1 an so on...) I want to see these 12 different percent dissolved of 12 different tablets at one column and 12 different raw of report method. 
  • Empower2019
    Empower2019
    Answer ✓
    Use labels in your sample set method to label the 12 timepoints and tablets, so your first sample could be U1, the second U2...then down to U12. 
    Then create a Peak,Real CF, incorporating your 12 CFs in a formula as follows, naming your CF something like "Overall_Percent_Result":

    EQ(Label,"U1")*T1S1+EQ(Label,"U2")*T1S2+EQ(Label,"U3")*T1S3+EQ(Label,"U4")*T1S4+EQ(Label,"U5")*T1S5+EQ(Label,"U6")*T1S6+EQ(Label,"U7")*T1S7+EQ(Label,"U8")*T1S8+EQ(Label,"U9")*T1S9+EQ(Label,"U10")*T1S10+EQ(Label,"U11")*T1S11+EQ(Label,"U12")*T1S12

    This formula will give you all your results in one column and to report them, put in the CF in a table and order by Label>Ascending so you can see the Label, Sample Name, Timepoint and The Percent Dissolved Result all displayed in one column (the CF "Overall_Percent_Result"above). 

Answers

  • Empower2019
    Empower2019
    Are you adding them together? You could make a peak, real CF with formula T1S1+T1S2...etc and this value would then populate for each peak, provided you have values for all 12 CFs.

Categories