Peak/Real/Calculated CF excluding a label

I have a Sample set with the following injections:
- 1P1 Standard (label P1)
- 5P Standard (label P)
- 1P2 Control (label P2)
- 1P Control (label P)

I need the following Cfs:
- %RSD Area P1 Standard + 5P Standard
- %RSD Area P1 Standard + 5P Standard + P Control

So I create the following Cfs:
- %RSD Area P1 Standard + 5P Standard
   Peak/Real/Calculated
   Result Set Only, Standards Only, Founds Only. 
   P%.%.SAME.%RSD(Area)
   It works perfectly!
- %RSD Area P1 Standard + 5P Standard + P Control
   Peak/Real/Calculated
   Result Set Only, Standards And Controls, Founds Only. 
   P%.%.SAME.%RSD(Area)
   It includes the injection P2 that works as control
   It does not work for my purpose

I was wondering whether it is possible to create a custom field excluding a label (P2) in this case.

Thanks in advance


Comments

  • A simple way to accommodate this is adding a sample, text custom field to your sample set and use this in your formula. Create a Sample, Text custom field called Reference or something similar. In the rows for P1, P and P (1P1 Standard, 5P Standard and 1P Control, populate reference with the word RSD. Amend the second formula then:

    P%.%.SAME.%RSD(Area*(EQ(Reference,"RSD")))

    This way Empower will only calculate the %RSD of Areas where the CF called Reference is populated with RSD and exclude the other one. 

    Hope this helps.