-
- Posts: 1
- Joined: Thu Oct 19, 2017 6:19 pm
I'm trying to figure out how to create an Empower custom field that would allow me to calculate the percent difference for multiple samples at multiple timepoints.
My Samples are as follows:
Sample 1 at 0 Hours
Sample 2 at 0 Hours
Sample 3 at 0 Hours
Sample 1 at 4 hours
Sample 2 at 4 hours
Sample 3 at 4 hours
Sample 1 at 6 hours
Sample 2 at 6 hours
Sample 3 at 6 hours
Sample 1 at 8 hours
Sample 2 at 8 hours
Sample 3 at 8 hours
The percent difference would be calculated for each sample as follows:
(Amount for Sample X at Y hours / Amount for Sample X at 0 hours); where X = Sample number 1, 2 or 3 and Y = Hours
I’ve tried to use the following sample labels
Label; Sample Name
A0; Sample 1 at 0 Hours
B0; Sample 2 at 0 Hours
C0; Sample 3 at 0 Hours
A; Sample 1 at 4 hours
B; Sample 2 at 4 hours
C; Sample 3 at 4 hours
A; Sample 1 at 6 hours
B; Sample 2 at 6 hours
C; Sample 3 at 6 hours
A; Sample 1 at 8 hours
B; Sample 2 at 8 hours
C; Sample 3 at 8 hours
Is there a wildcard or formatting trick that would allow me to use the “SAME” command?
I have tried the following without luck at
SAME.%.%.Amount / SAME”0”.%.%.Amount
SAME.%.%.Amount / SAME0.%.%.Amount
SAME.%.%.Amount / SAME’0’.%.%.Amount
Any suggestions would be much appreciated.
Thank you
