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