created a formula field called Fieldname which I wish to filter data through select expert. is this the right way? or do I need to create a parameter?
In Formula editor this is the formula used:
If table1.column1 in [value1, value2,value3, value4] then column1
else if isnull table1.column1 then table2.column2.

In short if table1.column1 is in the 4 values pick that value else if table1.column1 has null values pick up value from table2.column2. Table1 and table2 are inner joined. This value of Formula field is just for filtering data and is not required to display in the report.
I am NOT getting the desired result. Any suggestions appreciated.




 

Thanks. But It didn't help. Is there any other way round?

I am joining 2 tables which has 1 column called state. I wish to check if table1.state IN ["value1, value2] then pick table1.state else if table1.column1 has null values pick up value from table2.state. Any suggestions appreciated.

Thanks Sastry. Yes I did create a formula field and in record selection did select formula field = True, then I get zero results.