Skip to main content
C
Cozmo2
Inspiring
April 13, 2015
Question

Calculated Field Counts Off

  • April 13, 2015
  • 1 reply
  • 535 views

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 has been closed for replies.

1 reply

C
Cozmo2Author
Inspiring
April 14, 2015

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.

EddieLotter
EddieLotter
Inspiring
April 16, 2015

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices