Select in Field - inserting a function

[Anonymous]

Hi Experts,

I'd like to only select rows (via a button) that satisfy a function. I first have a variable (vTestVariable) in a slider object for the user to select anywhere from 0-100. Upon clicking the button, it should only select ID's where the function below is satisfied:

Value where Type=A minus Value where Type=B should be >= vTestVariable

The table of data I am working with resembles below:

ID	Value	Type
ABC100	60	A
ABC100	10	B
DEF999	90	A
DEF999	80	B

So if vTestVariable = 30 and the button is pressed, only ID=ABC100 should in the selection because 60-10>=30. DEF999 should not be part of selection because 90-80 < 30. Any ideas how I can implement this? I was trying to use "Select in Field" Action but finding it tricky what field to put and what search string is.

Thanks!

[sunny_talwar · Accepted solution]

Try this as search string

='=Sum({<Type = {"A"}, ID>} Value) - Sum({<Type = {"B"}, ID>} Value) >= vTestVariable'