Calculated Field Counts Off

Explorer ,
Apr 13, 2015 Apr 13, 2015

Copy link to clipboard

Copied

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.

TOPICS
Reporting

Views

362

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Apr 14, 2015 Apr 14, 2015

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Apr 16, 2015 Apr 16, 2015

Copy link to clipboard

Copied

LATEST

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines