Method Community

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

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