mstemp Red Ribbon

Ding…Ding…Ding!! That works! case when {number} IN ('JE72624','JE72775') then 1 else 0 end Thank you @Francesca Nicole Mendoza-Oracle @Divya Unnikrishnan Please note that you need single quotes. Also, (and this is very strange) If I filter on Document Number by itself, the system requires just the numeric portion of the…

Hi @Divya Unnikrishnan Thank you so much for trying to help me solve this issue. I'm obviously doing something wrong. I'm entering exactly what you specified: case when {number} IN (xxxxx,xxxxx) then 1 else 0 end but it's not working. The attached image shows what I entered, what you said to enter, and the error results…

@Divya Unnikrishnan I'm getting this error I tried using quotes in the "IN" and not using quotes. I tried with and without the "JE" before the document number. I also tried CASE {WHEN {number} IN ("JE74999") THEN 1 } ELSE 0 END [with curly brackets after the word CASE and before ELSE)

@Divya Unnikrishnan This is a great solution when I need to filter on a few values. It gets me thinking about using an inner join statement as a filter. What I've done in other systems is create a temporary file with the values I want to filter and then join that temporary file to the transaction file. This join acts like…

Thank you, Akhil. I am aware of the Use Expressions functionality. I was hoping to use a more streamlined approach implied by the term "ANY." I guess ANY does not always mean ANY. Knowing that I can use it with some fields but not others is helpful. Is there any place (no pun intended) I can find a list of which fields ANY…