open lab intelligent report

[varossf]

This is possible by making hidden tables but then i have to show you it once using webex. That would clarify it easier. You can make hidden tables, store the calculated results in a matrix and display it in the next table. Small trick but very easy.
If you are using OpenLAB2 you can do this by Custom Calculations even easier.

[jimsmiths]

Great! This question and all the answers give me the lot of knowldge. But What is the best place if we want to buy touka kirishima cosplay

[varossf]

Hi Kris,

Let us assume the following:
- multiple injections, like 6
- 2 compounds in each injection
- each compound needs to be Averaged
- Use Sample Label to distinquish between Set 1 and Set 2

Create a table where you want your statistics on, e.g. Area
In the Area Column, under Column Properties -> Value, save it as an expression, Aggregate and Category [Injection_Sample_Label & Compound_Name]. Group it and Repeat per Compound_Name And Filter set to Sample_Label = Set 1
Repeat this for Set 2

Now you have the Aggregate being calculated for each compound and each Calibration Group (Sample_Label 1 and 2)

Now you can call for each compound and calibration set the required statistical results.

Hi,

what about with the systems with two compounds?
Report calculate average area for both of compounds but when I define it like variable in Summary Calculations, in Expressions IR used only one average area of the two. I need results from control area/average area of Compound1 and control area/average area of Compound2 too in the same table.

Hi ,

I have figured out what these numbers refer to , thanks for your help

I am trying to do a simple standard verification using this software as below:

Mean Area S1/ Mean Area S2 *WT S2/WT S1

How would you create an expression like this in intelligent report
I know how to reprot means ,and weights would be entered into sequence table, just not sure how to combine 4 result varaibles into one expression and filter

Thanks again

This one is simple, just create 2 tables, one for S1 and 1 for S2, calculate the average Area per S and store that as a variable. Standard weight can be entered in the sequence or as a report variable. Then just set up that calculation. Done it, got the T shirt.