-
- Posts: 10
- Joined: Fri Jun 11, 2021 4:57 pm
I want to set up customs fields to automatically calculate differences and ratio between 2 standards.
The common practice I use is:
6 injections of standard 1 (label is Std1)
and
2 injections of standard 2 (label is Std2)
then I compare, with correction by mass, my standard areas 1 and 2.
In order to achieve this I already have create these custom field :
- Concordance
= ((StdCheckAveStd1/StdCheckAveStd2)*(Std2SampleWt/Std1SampleWt))
(Uses the other Custom Fields below to do final Calculation)
- StdCheckAveStd1 and StdCheckAveStd2
= STD1.%..AVE(Area) or STD2.%..AVE(Area)
(Averages the Areas of Std1 and Std2)
- Std1SampleW1 and Std1SampleW2
= Std1Check..(Value) or Std2Check..(Value) ' where Value is the standard amount (mg)
(Uses the weight of Std1 and Std2)
With this calculation I manage to calculate the ratio but I would also like to calculate the difference.
Here is the EXCEL formula that I use today and that I do not know how to transcribe on empower :
RF1 = AREA_Std1 / amount Std1
RF2 = AREA_Std2 / amount Std2
=ABS(RF1-RF2)/MAX(RF1,RF2)
TL;DR : How to use MAX function in EMPOWER in order to get MAX AREA between AVERAGE Standard 1 and AVERAGE Standard 2 ?
Thans you for reading me,
Maxime.