By using this website, you agree to our Terms of Use (click here)
How can I get a GI to return only rows that meet a certain condition when the condition is calculated from two values, X & Y, in the Results Grid?
I can use: iif ((X/Y < 100) or (X/Y > 300), X/Y , 0.01)
in the Results Grid and then filter the results to not display any rows with 0.01 but I'd rather not get the false rows to display at all.
Thanks!
So you only want rows where x/y < 100 or x/y > 300?
Isn't that the same as x < 100 * y or x > 300 * y
If so then that's 2 conditions, Data Field is X, 100 * y and 300 * y would be formulas.
You can't use formulas on the left side of conditions, only datafields (which includes parameters).
@royce-lithgo
Thanks! I think I was too focused on doing calculations in the Results Grid.
Online Members
