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

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
    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
    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

  • 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.

Welcome!

It looks like you're new here. Sign in or register to get started.