-
- Posts: 3
- Joined: Mon Feb 04, 2013 1:22 pm
I am having some troubles using the EMPOWER 3 custom fields and I am not sure if what I am trying to do is possible or not in this software.
I will explain the case the best I can.
I work with 3 samples, I weigh 3 replicates of each sample and I inject 3 times each replicate
Label____Inj___Average/RSD%___Final Average/RSD%
U0101____3
U0102____3
U0103____3______U01
U0201____3
U0202____3
U0203____3______U02
U0301____3
U0302____3
U0303____3______U03_______________U
I create the 3 custom fields "Interinjection average" for U0101, U0102 and U0103 with this syntax:
U0101.%..AVERAGE(AMOUNT)-->Name: U0101
U0102.%..AVERAGE(AMOUNT)-->Name: U0102
U0103.%..AVERAGE(AMOUNT)-->Name: U0103
I know that I coud use an easier syntax for that: "SAME.%..AVERAGE(AMOUNT)" and avoid the creation of 3 different custom fields, but after that I want to do the average of U0101+U0102+U0103
So for that, I create "interreplicate average" custom field with this syntax: (U0101.%..AVERAGE(AMOUNT)+U0102.%..AVERAGE(AMOUNT)+U0103.%..AVERAGE(AMOUNT))/3
The other possible option is to use this: "U01%.%..AVERAGE(AMOUNT)"
But with that syntax,it will take the 9 injection values instead of taking the 3 average values.
I know that the result will be the same in this case (Average), but when talking about RSD%, the result is not the same if we take the 9 injection values or the 3 average values.
So my question is:
Is it possible to create a custom field that does the average or RSD% of other created custom fields???
Which syntax and connectors do I need to use in the syntax between them (,./"[])?
For example :
AVE(U0101,U0102,U0103)
AVE(U01,U02,U03)
RSD%(U0101,U0102,U0103)
RSD%(U01,U02,U03)
If it is not possible....is there any other way to perform this calculations in EMPOWER3?
Thank you very much in advance
Best Regards
Lander