Set Analysis to get Distinct Field

[eduardo_dimperio]

Hi people,

I have three fields NAME_SYSTEM, OID_GROUP and DATA. I want to count how many NAME_SYSTEM's i have but unfortunately my other fields have more that one value for each NAME_SYSTEM so my count doesn't right.

I tried this, but not worked:  Count(DISTINCT{1-$<DATA={'Nao Agendado'}>}NAME_SYSTEM)

Input:

Expected Output:

[eduardo_dimperio]

Hi Stefan!

More or less, this Count(DISTINCT{1-$<DATA={'Nao Agendado'}>}NAME_SYSTEM) and this Count(DISTINCT {$<DATA -={'Nao Agendado'} >}NAME_SYSTEM) return the same result. The diference was create a new field only with two states Agendado and Nao Agendado.

But thank you for your help