Show counts by disposition

[Cozmo2]

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?

[EddieLotter]

Is "Accepted" a field in your result set?

[Cozmo2]

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 · Accepted solution]

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)

[Cozmo2]

Thank you for your help!