Skip to main content
Inspiring
Apr 13, 2015 8:39 PM UTC
Question

Calculated Field Counts Off

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.

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

Cozmo2Author
Inspiring
Apr 14, 2015 4:25 PM UTC

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.

Translate
EddieLotter
Inspiring
Apr 16, 2015 9:27 PM UTC

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.

Cheers

Eddie

Translate