Hey everyone,
This is my dilemma, I am trying to find duplicate purchasing ID's and have them labeled as Multi in the next column. This is what I have so far:
if(count (distinct [PURCHASE_ID] ) >1 ) THEN ('MULTI') ELSE ('').
This code does not return an error message, but every row in the column now has Multi in it. I am not sure what I am missing here, so if anyone could help me, I would greatly appreciate it!
This is my dilemma, I am trying to find duplicate purchasing ID's and have them labeled as Multi in the next column. This is what I have so far:
if(count (distinct [PURCHASE_ID] ) >1 ) THEN ('MULTI') ELSE ('').
This code does not return an error message, but every row in the column now has Multi in it. I am not sure what I am missing here, so if anyone could help me, I would greatly appreciate it!