How to create a CF to calculate relative difference between 2 injections

Hi,

I would like to create a custom field to calculate the relative difference of duplicate assay injections.

The relative difference is calculated by following formula:

(Assay result 1 - Assay result 2)/ average *100

The assay result is calculated with following CF:

Amount/Reference_Weight_Theor*Sample_Weight_Theor*Density*100

The sample set is created as follows:

Label

Injection

Sample name

R

6

Reference

S1

1

Sample 1 Preparation. 1

S2

1

Sample 1 Preparation. 2

S3

1

Sample 2 Preparation. 1

S4

1

Sample 2 Preparation. 2

S5

1

Sample 3 Preparation. 1

S6

1

Sample 3 Preparation. 2

Is there an easy way to set up a custom field to calculate the relative difference?


Comments

  • I solved my problem after a long search...
  • I dont know if this is how you solved it but you could use a peak enum CF that references the labels and then performs the calculation for those labels.