Custom Fields for Average and RSD - Advanced
I am trying to build custom fields to calculate average and %RSD across several custom fields for accuracy studies. Each spike level has a different field based on CConst1,2,3 so that I can use for multiple components in one sample set.
Basic setup of samples:
Label # replicates Spike Level Recovery custom field
U1 3 1 RecoveryCConst1
U2 3 2 RecoveryCConst2
U3 3 3 RecoveryCConst3
I need to calculate the overall average and %RSD across these three custom fields. I can't do it in report columns since the difference Recovery custom fields won't show up in a single column.
What syntax can I use to have AVE or RSD functions use different custom fields based on injection?
I've tried these but did not return any values...all other fields were working.
AVE(U1..(RecoveryCConst1)&U2..(RecoveryCConst2&U3..(RecoveryCConst3))
AVE(EQ(Label,U1)*RecoveryCConst1+EQ(Label,U2)*RecoveryCConst2+EQ(Label,U3)*RecoveryCConst3)
Basic setup of samples:
Label # replicates Spike Level Recovery custom field
U1 3 1 RecoveryCConst1
U2 3 2 RecoveryCConst2
U3 3 3 RecoveryCConst3
I need to calculate the overall average and %RSD across these three custom fields. I can't do it in report columns since the difference Recovery custom fields won't show up in a single column.
What syntax can I use to have AVE or RSD functions use different custom fields based on injection?
I've tried these but did not return any values...all other fields were working.
AVE(U1..(RecoveryCConst1)&U2..(RecoveryCConst2&U3..(RecoveryCConst3))
AVE(EQ(Label,U1)*RecoveryCConst1+EQ(Label,U2)*RecoveryCConst2+EQ(Label,U3)*RecoveryCConst3)
0
Answers
-
For the average one, you could add the 3 CFs together and divide by 3.
So, (CF1+CF2+CF3)/3
1
