Need help suppressing duplicate row

[jpeters01]

Hi, My data looks like this:

Description Area NDC(string)
Acetaminophen ED 123
Actaminophen ICU 1234
Acetaminophen ED 123
Acetaminophen 4W 12345
Acetaminophen TCU 222
Acetaminophen 3S 222

I need add an X in a column when the Area is ED and I need to remove duplicate NDC's so that the data looks like this:
Description Area NDC(string) ED
Acetaminophen ED 123 X
Actaminophen ICU 1234
Acetaminophen 4W 12345
Acetaminophen TCU 222

I am trying to use a suppression formula on the details section, like {TABLE.NDC} = next ({TABLE.NDC}) but this is not working, it suppresses some of the duplicate NDC rows but not all of them. I tried creating a formula for the NDC to make it a number and then used that for the suppression formula but that didn't work either.

Can you tell me what I am doing wrong?

Thank you

 

[lbass]

You are in the wrong forum. Please repost in forum149 or forum767.

-LB