Re: Grid filter: how to set a filter by comparing two columns

Method_Ben — Thu, 26 Nov 2015 22:44:36 GMT

Hi Alex,

There isnt a way to set a grid filter to compare the values in two columns.

If you did need to set a grid filter where Column A > Column B for example, you could create a new integer field, Column C, on this table, and populate this field using a loop through table action which performs some basic calculation like Column A - Column B. This would leave you with either a Positive Integer (ie Column A > Column B) or a negative integer (ie Column B > Column A) . Finally, you would then set the Filter to display only values where your created Column C is greater than 0.

Ill do some more testing and see if I can come up with anything else.

Thanks Alex.

Regards,

Ben

Grid filter: how to set a filter by comparing two columns

alexhuang — Thu, 26 Nov 2015 22:22:46 GMT

Hi,

I have a grid with several columns. Is it possible to add a filter to this grid, which compare two columns of this grid? For example, I have two columns(Col_A, and Col_B), can I set a filter like (Col_A > Col_B)? Thanks.

Alex

Method:Classic General Q&A

Re: Grid filter: how to set a filter by comparing two columns

Grid filter: how to set a filter by comparing two columns