Filtering by Signal and Value in Chemstation

Hello,

What version of Chemstation are you using? Do you name the compound the same in both signals? Is this a single sample report or a summary? The key will be to store the second channel result in a variable keyed on compound name if the names are the same.

Marty 

Hello, we have Chemstation C.01.08 [210]. The compound does have the same name, and this is a sequence summary report. 

Hello,

Maybe I am missing something, but when I look at that logic it seems the 3rd test is not needed. Actually, it looks to me like only test 2 is really needed. The only time you show the amount from signal 2 is when it is less than or equal to 0.250.

Marty 

I see what you mean, that's right. I am trying to get the table to display signal 2 when it is less than 0.250, but it simply displays all values.

where the DADConc and FLDConc are compound amounts given by each signal, like this:

Hello,

Create a hidden table at the top filtered on signal 2. Store the compound amount as an aggregator keyed on Injection_id + compound_name. In the display table filter it for signal 1 and then use something like the expression below to choose which value to display. You can use the hard coded value instead of a report parameter as I did. Do not place the value inside "" as that will denote it as text. Since you are storing only one value you can use any of the aggregate functions' min, max, sum to retrieve the value. Please note you cannot use a variable as that will not accept keys with multiple components. 

=IF(Max(CompAmt(Injection_ID + Compound_Name)) <= ReportingLimit,Max(CompAmt(Injection_ID + Compound_Name)),Compound_Amount)

Hello,

Create a hidden table at the top filtered on signal 2. Store the compound amount as an aggregator keyed on Injection_id + compound_name. In the display table filter it for signal 1 and then use something like the expression below to choose which value to display. You can use the hard coded value instead of a report parameter as I did. Do not place the value inside "" as that will denote it as text. Since you are storing only one value you can use any of the aggregate functions' min, max, sum to retrieve the value. Please note you cannot use a variable as that will not accept keys with multiple components. 

=IF(Max(CompAmt(Injection_ID + Compound_Name)) <= ReportingLimit,Max(CompAmt(Injection_ID + Compound_Name)),Compound_Amount)

That worked perfectly, thank you so much for your help, it is much appreciated!