Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding duplicate values in report studio

Status
Not open for further replies.

jdmas

Technical User
Feb 19, 2015
1
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top