List Codes that are not in the lookup table

[aquinojason]

Hi,

I have a list of accounting codes in a lookup table. I use that to identify applications under that accounting code and . If the accounting code is not in the lookup table, it becomes "Others". How do I generate a report wherein the results will only list those "Others" and showing the accounting code used?

Thanks and Regards,

[ITWhisperer · Accepted solution]

| where accountingCode="Others"

[aquinojason]

Hi,

Thank you very much for the response and support. I have learned a lot from your answers.