I have created an event program where one of the data elements is beneficiary code. The beneficiary code is a text data type. My use case says the same code can be entered several times and what I want is to create a program indicator to eliminate the repetitive appearance of the same data. Like using DISTINCT clause to count the code only once.
From the above example, I should get 8, not 12 as a result because the beneficiary code is repeated in some cells.
I am wondering if any one form the community help me create the program indicator.