Skip to main content
C
Cozmo2
Inspiring
January 26, 2015
Answered

Show counts by disposition

  • January 26, 2015
  • 1 reply
  • 864 views

I need to show by counselor how many students were accepted, cancelled, enrolled, etc. I also need grand totals. I tried using a calculated field where I entered:

iif(trim(query.dispos) eq DE("Accepted"), 1, 0) in the perform calculation on field but I always get 0 for the answer. I tried using single quotes around Accepted but that didn't make a difference.

Any ideas?

This topic has been closed for replies.
Correct answer EddieLotter

Then don't use the delay evaluation function. Change your code to the following:

iif(trim(query.dispos) eq query.Accepted, 1, 0)

However, if you are trying to determine its value then use the following:

iif(trim(query.dispos) eq "Accepted", 1, 0)

1 reply

EddieLotter
EddieLotter
Inspiring
January 26, 2015

Is "Accepted" a field in your result set?

C
Cozmo2Author
Inspiring
January 27, 2015

Yes it is.

Bonni

---

Bonni Harris

Database Analyst

Eureka College

300 E. College Avenue

Eureka, IL 61530-1500

309-467-6467

On Mon, Jan 26, 2015 at 4:57 PM, Eddie Lotter <forums_noreply@adobe.com>

EddieLotter
EddieLotterCorrect answer
Inspiring
January 27, 2015

Then don't use the delay evaluation function. Change your code to the following:

iif(trim(query.dispos) eq query.Accepted, 1, 0)

However, if you are trying to determine its value then use the following:

iif(trim(query.dispos) eq "Accepted", 1, 0)

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