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

JokeD
JokeD
in Software Products

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

  • JokeD
    JokeD
    I solved my problem after a long search...
  • Empower2019
    Empower2019
    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. 

Categories