CountIF Field equals a text variable

[bsnoles]

I have a table with multiple fields and I need to count the number of records with the text variable of 'Update Record' based upon another field but I only want to count the 'Update Record' once based upon the second field.  For example:

1st field name is Record Reporting Category is equal to 'Update Record' then count but only count it one time based upon the 2nd field name of Record UID.

Any help would be appreciated.

[MendyS]

hi @bsnoles 

you need to Used with set analysis and distinct , 
something like  - 
Count ({<Reporting Category={'Reporting Category'}>}Distinct Record UID)

[bsnoles]

That did not work for me....let me try to explain further.  I have 60,583 distinct UID records of which some of them have the word 'Update Record' in a field called Reporting Category.  I need to extrapolate and count those records with 'Update Record' in the Reporting Category field.

[BrunPierre]

Count ({<Reporting Category={"*Update Record*"}>}Distinct UID)

[MendyS]

@bsnoles  can you send a screenshot with a sample from your data?  

[bsnoles]

Peter - sorry but it is giving me a count of zero but I do have records with 'Update Record' in that Reporting Category field.

[bsnoles]

Here is a snap of my two columns....I only need to count the UID once every time 'Update Record' is present.

[BrunPierre]

As @MendyS mentioned It would be useful to see a sample of the data.

[MendyS]

@bsnoles 

Count ({<CCarR Record Reporting Category={"*Update Record*"}>}Distinct CCarR Record UID)

[MendyS]

Count ({<CCarR Record Reporting Category={"*Update Record*"}>}Distinct CCarR Record UID)

[bsnoles]

Mendy - how do I do the formula above it the CCaR Record Reporting Category is Null and still be a distinct UID?