I have a Calculated field that is set up for a Distinct Count the Perform Calculation on looks like this:
(query.prg_cod EQ "UNDERGRAD " AND query.level_ LTE "2" AND query.soc_sec)
Sometimes it counts the when the prg_cod is not equal to "UNDERGRAD " and sometimes it counts when the level is "3" or "4". It also counts the first record in the group regardless of the values.
I am using the Report Builder.
Is there a better place to try to accomplish this? I have several different counts (Transferred, Level 1 or 2, Transferred Level 3, not Transferred Level 1 or 2, etc) and I do not want to write a query for each one.
Yes, the better place to do this is on your database server.
See my response to your other question about calculated fields. The concept is the same.