Hello! So I have a data table, and I would like to "flag" all invoices that contains product "A", something like this:
Invoice - Product - Flag
I123 - A - 1
I123 - B - 1
I456 - C - 0
I456 - B - 0
I789 - D - 1
I789 - A - 1
I tried a couple of "IF"s but not getting what I want. Any ideas?
Bookmarks