I have a 3 variables that is comparing values from 2 different queries in each variable. I can not seem to put a quick filter on any of them. So I did a global filter. It works on just one of them but I want to do an or statement on the 3 of them.
briancomer (BOB member since 2009-10-26)
Are you using any aggregate functions in the variables?
Jansi (BOB member since 2008-05-12)
No this is one of the variables and the other 2 are exactly the same just change the fields
=If(<Quality Code(Query 1 with Customer_History)><><Quality Code(Query 2 with Customer_History)> ) Then “999” Else “0”
Basically I want to look at those three variables and filter like this variable1=9999 or variable2=9999 or variable3=9999