Hi!

Is it possible to show a compound's multiplier in the report? I can't find any way Maybe with some revererse engineering : from the ratio of the cal curve' slope and the calibration amount…

Peter

(Openlab 2.4)

Hi!

Is it possible to show a compound's multiplier in the report? I can't find any way Maybe with some revererse engineering : from the ratio of the cal curve' slope and the calibration amount…

Peter

(Openlab 2.4)

- 2 people found this helpful
Hello,

You cannot display it directly on the report as a single field. However in CDS 2.x, you can recalculate it in IR or as in the example below in CC. Using the fact that compound concentration(CC) is calculated by the equation CC = CA(Compound Amount) * Multipliers */ DilutionFactors * CM(Compound Multipliers) we can solve for CM. We do need to do the calculation based on your methods setting for the use of dilution factors in the equation so I have provided both. The other options in the method that can effect the calculation are normalization and calculating mass % which would require different CC or IR formulas but can still be done.

Marty

`Compound_Concentration/Compound_Amount/CurrentSample.Multiplier(1)/CurrentSample.Multiplier(2)/CurrentSample.Multiplier(3)/CurrentSample.Multiplier(4)/CurrentSample.Multiplier(5)/CurrentSample.DilutionFactor(1)/CurrentSample.DilutionFactor(2)/CurrentSample.DilutionFactor(3)/CurrentSample.DilutionFactor(4)/CurrentSample.DilutionFactor(5)`

Compound_Concentration/Compound_Amount/CurrentSample.Multiplier(1)/CurrentSample.Multiplier(2)/CurrentSample.Multiplier(3)/CurrentSample.Multiplier(4)/CurrentSample.Multiplier(5)*CurrentSample.DilutionFactor(1)*CurrentSample.DilutionFactor(2)*CurrentSample.DilutionFactor(3)*CurrentSample.DilutionFactor(4)*CurrentSample.DilutionFactor(5) You can definitely show the

**Sample**multipliers and dilution factors in OpenLab Reporting. The only challenge is that the multipliers are stored in the same field Sample_Multipliers and similarly Sample_DilutionFactors for the dilution factors. In either case, the individual factors are separated with semicolons, so if you want to get the individual values, you end up using a combination of split() and choose() functions:=Choose(1, Split(Sample_Multipliers, ";"))

If you have a fixed multiplier from the processing method for each compound, then you have to reverse engineer as Marty showed.

Kind regards

Andy

Hello,

You cannot display it directly on the report as a single field. However in CDS 2.x, you can recalculate it in IR or as in the example below in CC. Using the fact that compound concentration(CC) is calculated by the equation CC = CA(Compound Amount) * Multipliers */ DilutionFactors * CM(Compound Multipliers) we can solve for CM. We do need to do the calculation based on your methods setting for the use of dilution factors in the equation so I have provided both. The other options in the method that can effect the calculation are normalization and calculating mass % which would require different CC or IR formulas but can still be done.

Marty