Inlist or OR

[system]

Hello,

I need to create a variable in my report with functionality:

var= Where (InList( “EX” ,“M%”))

but it’s giving me syntax error. then what i did was i created like this

var = If InList( “EX” ,“M%”) Then

but this needs in the table which I don’t want to do it because it’s giving me some other additional info in the table which is not needed and I can’t even filter it later. if i don’t include this dimension it’s giving me computational error.

pls let me know if there’s any other way around.

Thanks.

---

gflores (BOB member since 2005-09-09)

[system]

Please, try this FAQ.

---

Andreas (BOB member since 2002-06-20)

[system]

Andreas,

Thanks so much. I had to create another variable as mentioned in that FAQ. I am done.

Regards.

---

gflores (BOB member since 2005-09-09)