Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this as search string
='=Sum({<Type = {"A"}, ID>} Value) - Sum({<Type = {"B"}, ID>} Value) >= vTestVariable'
Try this as search string
='=Sum({<Type = {"A"}, ID>} Value) - Sum({<Type = {"B"}, ID>} Value) >= vTestVariable'